{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Footrest Positioning","HRMD (Full Rear Full Down)","Seat Set-up","Head Restraint Position","HRMD","HRMD (Verified)","BioRID","Summary","Additional points","Data Share"],"not_rendered":{"charts":1,"images":4,"macros":1,"external_links":0,"defined_names":44,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Footrest Positioning","index":0,"n_rows":59,"n_cols":16,"rows_kept":59,"cut":false,"hidden":false,"merged":[[0,10,0,13],[0,6,0,9],[54,1,55,1],[51,1,52,1],[0,1,4,4],[46,1,47,1],[8,1,9,1],[16,1,17,1],[40,1,41,1],[43,1,44,1],[21,1,22,1]]}
["Coordinate System",null,null,null,null,null,"Data Point Collection",null,null,null,"OEM Provided Points",null,null,null,null,"Select a fixed point for footrest height"]
["X positive forward",null,null,null,null,{"$f":"IF(A2 = \"X positive forward\",  1, IF(A2 = \"X positive rearward\", -1))","v":1},"Measurements","Value","Units",null,"Locations","X (mm)","Y (mm)","Z (mm)",null,"Outboard seat track reference point"]
["Y positive rightward",null,null,null,null,{"$f":"IF(A3 = \"Y positive rightward\",  1, IF(A3 = \"Y positive leftward\", -1))","v":1},"Seat Weight",null,"lbs",null,"Left front seatbolt",null,null,null,null,"Left front seatbolt"]
["Z positive downward",null,null,null,null,{"$f":"IF(A4 = \"Z positive downward\",  1, IF(A4 = \"Z positive upward\", -1))","v":1},"Mount Weight",null,"lbs",null,"Right front seatbolt",null,null,null,null,"Right front seatbolt"]
[null,null,null,null,null,null,"Mount ID",null,null,null,"Right rear seatbolt",null,null,null,null,"Right rear seatbolt"]
[null,"All coordinates are recorded in mm",null,null,null,null,"Left Track Angle",null,"degrees",null,"Left rear seatbolt",null,null,null,null,"Left rear seatbolt"]
[null,null,null,null,null,null,"Right Track Angle",null,"degrees"]
["1.2.3 Attachment of Seat/Head Restraint to Sled",null,"X","Y","Z"]
[null,"Fixed Seat Point Locations",null,null,null,null,"CMM Collection","X (mm)","Y (mm)","Z (mm)","Distances","∆X (mm)","∆Y (mm)","∆Z (mm)"]
[null,null,null,null,null,null,"Origin (IIHS origin by default)",0,0,0,"OEM",null,null,null,null,"X positive forward"]
[null,"Outboard seat track reference point",{"$f":"IF(H11=\"\", \"\", $H$11-$H$10)","v":""},{"$f":"IF(I11=\"\", \"\", $I$11-$I$10)","v":""},{"$f":"IF(J11=\"\", \"\", $J$11-$J$10)","v":""},null,"Outboard seat track reference point",null,null,null,"Front",{"$f":"IF(OR(L3 = \"\", L4 = \"\"), \"\", ABS(L3-L4))","v":""},{"$f":"IF(OR(M3 = \"\", M4 = \"\"), \"\", ABS(M3-M4))","v":""},{"$f":"IF(OR(N3 = \"\", N4 = \"\"), \"\", ABS(N3-N4))","v":""},null,"X positive rearward"]
[null,"Left front seatbolt",{"$f":"IF(H12=\"\", \"\", $H$12-$H$10)","v":""},{"$f":"IF(I12=\"\", \"\", $I$12-$I$10)","v":""},{"$f":"IF(J12=\"\", \"\", $J$12-$J$10)","v":""},null,"Left front seatbolt",null,null,null,"Rear",{"$f":"IF(OR(L6 = \"\", L5 = \"\"), \"\", ABS(L6-L5))","v":""},{"$f":"IF(OR(M6 = \"\", M5 = \"\"), \"\", ABS(M6-M5))","v":""},""]
[null,"Right front seatbolt",{"$f":"IF(H13=\"\", \"\", $H$13-$H$10)","v":""},{"$f":"IF(I13=\"\", \"\", $I$13-$I$10)","v":""},{"$f":"IF(J13=\"\", \"\", $J$13-$J$10)","v":""},null,"Right front seatbolt",null,null,null,"Right",{"$f":"IF(OR(L5 = \"\", L4 = \"\"), \"\", ABS(L5-L4))","v":""},{"$f":"IF(OR(M5 = \"\", M4 = \"\"), \"\", ABS(M5-M4))","v":""},"",null,"Y positive rightward"]
[null,"Right rear seatbolt",{"$f":"IF(H14=\"\", \"\", $H$14-$H$10)","v":""},{"$f":"IF(I14=\"\", \"\", $I$14-$I$10)","v":""},{"$f":"IF(J14=\"\", \"\", $J$14-$J$10)","v":""},null,"Right rear seatbolt",null,null,null,"Left",{"$f":"IF(OR(L6 = \"\", L3 = \"\"), \"\", ABS(L6-L3))","v":""},{"$f":"IF(OR(M6 = \"\", M3 = \"\"), \"\", ABS(M6-M3))","v":""},"",null,"Y positive leftward"]
[null,"Left rear seatbolt",{"$f":"IF(H15=\"\", \"\", $H$15-$H$10)","v":""},{"$f":"IF(I15=\"\", \"\", $I$15-$I$10)","v":""},{"$f":"IF(J15=\"\", \"\", $J$15-$J$10)","v":""},null,"Left rear seatbolt"]
[null,"Outboard seat track reference point",{"$f":"IF($B$16=$B$11,C11,IF($B$16=$B$12,C12,IF($B$16=$B$13,C13,IF($B$16=$B$14,C14,IF($B$16=$B$15,C15)))))","v":""},{"$f":"IF($B$16=$B$11,D11,IF($B$16=$B$12,D12,IF($B$16=$B$13,D13,IF($B$16=$B$14,D14,IF($B$16=$B$15,D15)))))","v":""},{"$f":"IF($B$16=$B$11,E11,IF($B$16=$B$12,E12,IF($B$16=$B$13,E13,IF($B$16=$B$14,E14,IF($B$16=$B$15,E15)))))","v":""},null,"Seat Reference Point 2 Forward",null,null,null,"IIHS",null,null,null,null,"Z positive downward"]
[null,"Check Seat Alignment to Sled",null,null,null,null,"Seat Reference Point 2 Rear",null,null,null,"Front",{"$f":"IF(OR(C12 = \"\", C13 = \"\"), \"\", ABS(C12-C13))","v":""},{"$f":"IF(OR(D12 = \"\", D13 = \"\"), \"\", ABS(D12-D13))","v":""},{"$f":"IF(OR(E12 = \"\", E13 = \"\"), \"\", ABS(E12-E13))","v":""},null,"Z positive upward"]
[null,null,null,null,null,null,"Center of Footrest",null,null,null,"Rear",{"$f":"IF(OR(C15 = \"\", C14 = \"\"), \"\", ABS(C15-C14))","v":""},{"$f":"IF(OR(D15 = \"\", D14 = \"\"), \"\", ABS(D15-D14))","v":""},{"$f":"IF(OR(E15 = \"\", E14 = \"\"), \"\", ABS(E15-E14))","v":""}]
[null,"Seat Reference Point 2 Rear",{"$f":"IF(H17=\"\", \"\", $H$17-$H$10)","v":""},{"$f":"IF(I17=\"\", \"\", $I$17-$I$10)","v":""},{"$f":"IF(J17=\"\", \"\", $J$17-$J$10)","v":""},null,"Additional Center of Footrest Points   ↓↓↓",null,null,null,"Right",{"$f":"IF(OR(C14 = \"\", C13 = \"\"), \"\", ABS(C14-C13))","v":""},{"$f":"IF(OR(D14 = \"\", D13 = \"\"), \"\", ABS(D14-D13))","v":""},{"$f":"IF(OR(E14 = \"\", E13 = \"\"), \"\", ABS(E14-E13))","v":""}]
[null,"Seat Reference Point 2 Forward",{"$f":"IF(H16=\"\", \"\", $H$16-$H$10)","v":""},{"$f":"IF(I16=\"\", \"\", $I$16-$I$10)","v":""},{"$f":"IF(J16=\"\", \"\", $J$16-$J$10)","v":""},null,null,null,null,null,"Left",{"$f":"IF(OR(C15 = \"\", C12 = \"\"), \"\", ABS(C15-C12))","v":""},{"$f":"IF(OR(D15 = \"\", D12 = \"\"), \"\", ABS(D15-D12))","v":""},{"$f":"IF(OR(E15 = \"\", E12 = \"\"), \"\", ABS(E15-E12))","v":""}]
[null,"Alignment Good?",null,{"$f":"IF(OR(D19=\"\",D20=\"\"),\"\",ABS(D19-D20))","v":""},null,{"$f":"IF(D21=\"\",\"\",IF(D21<5,\"Good\",\"Realign\"))","v":""}]
[null,"Positioning the Footrest"]
[null,null,null,null,null,"Floor Height"]
[null,"Target Footrest Z-Coordinate",null,null,{"$f":"IF(F24=\"\",\"\",E16+(F4*F24))","v":""}]
[null,"Center of Footrest",{"$f":"IF(H18=\"\", \"\", H18-$H$10)","v":""},{"$f":"IF(I18=\"\", \"\", I18-$I$10)","v":""},{"$f":"IF(J18=\"\", \"\", J18-$J$10)","v":""},{"$f":"IF(E25=\"\",\"\",ABS($E$16-E25))","v":""}]
[null,null,{"$f":"IF(H19=\"\", \"\", H19-$H$10)","v":""},{"$f":"IF(I19=\"\", \"\", I19-$I$10)","v":""},{"$f":"IF(J19=\"\", \"\", J19-$J$10)","v":""},{"$f":"IF(E26=\"\",\"\",ABS($E$16-E26))","v":""}]
[null,null,"","","",""]
[null,null,"","","",""]
[null,null,"","","",""]
[null,null,"","","",""]
[null,null,"","","",""]
[null,null,"","","",""]
[null,null,"","","",""]
[null,null,"","","",""]
[null,null,"","","",""]
[null,null,"","","",""]
[null,null,"","","",""]
[null,null,"","","",""]
[null,null,"","","",""]
[null,null,"","","",""]
[null,"Surface of Footrest"]
[]
[null,"Final Surface of Footrest",{"$f":"LOOKUP(2, 1/(H18:H33<>\"\"), H18:H33)-$H$10","v":{"$error":"#N/A"}},{"$f":"LOOKUP(2, 1/(I18:I33<>\"\"), I18:I33)-$I$10","v":{"$error":"#N/A"}},{"$f":"LOOKUP(2, 1/(J18:J33<>\"\"), J18:J33)-$J$10","v":{"$error":"#N/A"}}]
[null,"Final Footrest Height"]
[]
[null,"Final Footrest Height",null,null,null,{"$f":"ABS(E16-E43)","v":{"$error":"#VALUE!"}}]
[null,"Other Measurements"]
[]
[null,"Design Track Angle"]
[null,"Left Track Angle",null,null,null,{"$f":"H6","v":0}]
[null,"Right Track Angle",null,null,null,{"$f":"H7","v":0}]
[null,"Mount Information"]
[]
[null,"Mount ID Number",null,null,null,{"$f":"H5","v":0}]
[null,"Ballast Information"]
[]
[null,"Seat Weight",null,null,null,{"$f":"H3","v":0}]
[null,"Mount Weight",null,null,null,{"$f":"H4","v":0}]
[null,"Ballast Weight",null,null,null,{"$f":"300-178-F58-F57","v":122}]

{"sheet":"HRMD (Full Rear Full Down)","index":1,"n_rows":60,"n_cols":26,"rows_kept":60,"cut":false,"hidden":true,"merged":[[11,2,11,4],[10,2,10,4],[0,1,4,5],[8,1,9,1],[12,2,12,4],[33,1,34,1],[43,5,44,5],[13,1,14,1],[16,2,16,3],[16,4,16,5],[18,1,19,1],[17,2,17,3],[17,4,17,5],[25,1,26,1]]}
["Coordinate System"]
[{"$f":"'Footrest Positioning'!A2","v":"X positive forward"}]
[{"$f":"'Footrest Positioning'!A3","v":"Y positive rightward"}]
[{"$f":"'Footrest Positioning'!A4","v":"Z positive downward"}]
[]
[null,"All measurements are recorded in mm"]
[]
[]
[null,"Test Information"]
[]
[null,"Test ID"]
[null,"Year/Make/Model"]
[null,"Seat Positioning Procedure","RCAR Static Procedure"]
[null,"Seat Information"]
[null,null,"Weighted","Unweighted"]
[null,"Seatback Angle",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Horizontal ","Vertical",null,null,null,null,{"$f":"R20+R21","v":0}]
[null,"HR \"Test Position\" Height Adjustment Description",null,null,null,null,null,null,null,null,null,null,null,null,"Static rated position from field",null,"N/A","N/A","N/A"]
[null,"HR \"Test Position\" Tilt Adjustment Description",null,null,null,null,null,null,null,null,null,null,null,null,"Static rated position from sled",null,{"$f":"IF(Q20=\"\",\"\",IF(Z24=Z22,S22,IF(Z24=Z21,S21,IF(Z24=Z23,S23,S20))))","v":0},{"$f":"IF(R20=\"\",\"\",IF(Z24=Z22,T22,IF(Z24=Z21,T21,IF(Z24=Z23,T23,T20))))","v":0},{"$f":"IF(OR(Q18=\"\",R18=\"\"),\"\",IF(AND(Q18<=70,R18<=60),\"Good\",IF(AND(Q18<=90,R18<=80),\"Acceptable\",IF(AND(Q18<=110,R18<=100),\"Marginal\",\"Poor\"))))","v":"Good"}]
[null,"HRMD Information",null,null,null,null,null,null,null,null,null,null,null,null,"Test position",null,{"$f":"C29","v":0},0,null,null,"Hor Rating","Vert Rating","Overall Rat","App Ratings"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Down rearward",null,0,0,{"$f":"IF(Q20=\"\",\"\",Q20)","v":0},{"$f":"IF(R20=\"\",\"\",R20)","v":0},{"$f":"IF(S20<=70,1,IF(S20<=90,2,IF(S20<=110,3,4)))","v":1},{"$f":"IF(T20<=60,1,IF(T20<=80,2,IF(T20<=100,3,4)))","v":1},{"$f":"IF(OR(U20=4,V20=4),4,IF(OR(U20=3,V20=3),3,IF(OR(U20=2,V20=2),2,1)))","v":1},{"$f":"W20","v":1},{"$f":"IF(AND(X20<=X21,X20<=X22,X20<=X23),X20,5)","v":1},{"$f":"IF(Y20<>5,SQRT(S20^2+T20^2),\"\")","v":0}]
[null,"Right Leg",5,null,null,null,null,null,null,null,null,null,null,null,"Up rearward",null,0,0,{"$f":"IF(OR(Q20=\"\",Q21=\"\"),\"\",IF(ISEVEN(AVERAGE(Q20:Q21)),ROUNDDOWN(AVERAGE(Q20:Q21),0),AVERAGE(Q20:Q21)))","v":0},{"$f":"IF(OR(R20=\"\",R21=\"\"),\"\",IF(ISEVEN(AVERAGE(R20:R21)),ROUNDDOWN(AVERAGE(R20:R21),0),AVERAGE(R20:R21)))","v":0},{"$f":"IF(S21<=70,1,IF(S21<=90,2,IF(S21<=110,3,4)))","v":1},{"$f":"IF(T21<=60,1,IF(T21<=80,2,IF(T21<=100,3,4)))","v":1},{"$f":"IF(OR(U21=4,V21=4),4,IF(OR(U21=3,V21=3),3,IF(OR(U21=2,V21=2),2,1)))","v":1},{"$f":"IF(OR('Seat Set-up'!C27=\"Fixed\",'Seat Set-up'!C27=\"Not Equipped\"),5,'HRMD (Full Rear Full Down)'!W21)","v":1},{"$f":"IF(AND(X21<=X20,X21<=X22,X21<=X23),X21,5)","v":1},{"$f":"IF(Y21<>5,SQRT(S21^2+T21^2),\"\")","v":0}]
[null,"Left Leg",5,null,null,null,null,null,null,null,null,null,null,null,"Up forward",null,0,0,{"$f":"IF(OR(Q20=\"\",Q22=\"\"),\"\",IF(ISEVEN(AVERAGE(Q20,Q22)),ROUNDDOWN(AVERAGE(Q20,Q22),0),AVERAGE(Q20,Q22)))","v":0},{"$f":"IF(OR(R20=\"\",R22=\"\"),\"\",IF(ISEVEN(AVERAGE(R20,R22)),ROUNDDOWN(AVERAGE(R20,R22),0),AVERAGE(R20,R22)))","v":0},1,1,1,{"$f":"IF(OR('Seat Set-up'!C28=\"Fixed\",'Seat Set-up'!C27=\"Fixed\",'Seat Set-up'!C28=\"Not Equipped\",'Seat Set-up'!C27=\"Not Equipped\"),5,'HRMD (Full Rear Full Down)'!W22)","v":1},{"$f":"IF(AND(X22<=X20,X22<=X21,X22<=X23),X22,5)","v":1},{"$f":"IF(Y22<>5,SQRT(S22^2+T22^2),\"\")","v":0}]
[null,"Torso Angle without Head",null,{"$f":"90-C23","v":90},null,null,null,null,null,null,null,null,null,null,"Down forward",null,0,0,{"$f":"IF(OR(Q20=\"\",Q23=\"\"),\"\",IF(ISEVEN(AVERAGE(Q20,Q23)),ROUNDDOWN(AVERAGE(Q20,Q23),0),AVERAGE(Q20,Q23)))","v":0},{"$f":"IF(OR(R20=\"\",R23=\"\"),\"\",IF(ISEVEN(AVERAGE(R20,R23)),ROUNDDOWN(AVERAGE(R20,R23),0),AVERAGE(R20,R23)))","v":0},1,1,1,{"$f":"IF(OR('Seat Set-up'!C28=\"Fixed\",'Seat Set-up'!C28=\"Not Equipped\"),5,'HRMD (Full Rear Full Down)'!W23)","v":1},{"$f":"IF(AND(X23<=X20,X23<=X21,X23<=X22),X23,5)","v":1},{"$f":"IF(Y23<>5,SQRT(S23^2+T23^2),\"\")","v":0}]
[null,"Torso Angle with Head",null,{"$f":"90-C24","v":90},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MIN(Z20:Z23)","v":0}]
[null,"Torso Recline Angle Calculated",{"$f":"IF(C44=\"\",\"\",DEGREES(ATAN(ABS(C44-C46)/ABS(E44-E46))))","v":""}]
[null,"HRMD by Hand Measurements",null,null,null,null,null,"Fixed",null,null,null,"Height Lock",null,null,null,"Tilt Lock",null,null,null,"Tilt Lock"]
[]
[null,null,"Horizontal","Vertical","Static Rating from Field",null,null,null,"Horizontal","Vertical",null,null,"Horizontal","Vertical",null,null,"Horizontal","Vertical",null,null,"Horizontal","Vertical"]
[null,"Test Position"]
[null,"Down Rearward",null,null,null,null,null,"Down Rearward",{"$f":"IF(C30<=70,1,IF(C30<=90,2,IF(C30<=110,3,4)))","v":1},{"$f":"IF(D30<=60,1,IF(D30<=80,2,IF(D30<=100,3,4)))","v":1},null,"Average (DR UR)",{"$f":"IF(AVERAGE(C30:C31)<=70,1,IF(AVERAGE(C30:C31)<=90,2,IF(AVERAGE(C30:C31)<=110,3,4)))","v":{"$error":"#DIV/0!"}},{"$f":"IF(AVERAGE(D30:D31)<=60,1,IF(AVERAGE(D30:D31)<=80,2,IF(AVERAGE(D30:D31)<=100,3,4)))","v":{"$error":"#DIV/0!"}},null,"Average (DR DF)",{"$f":"IF(AVERAGE(C30,C33)<=70,1,IF(AVERAGE(C30,C33)<=90,2,IF(AVERAGE(C30,C33)<=110,3,4)))","v":{"$error":"#DIV/0!"}},{"$f":"IF(AVERAGE(D30,D33)<=60,1,IF(AVERAGE(D30,D33)<=80,2,IF(AVERAGE(D30,D33)<=100,3,4)))","v":{"$error":"#DIV/0!"}},null,"Average (DR UR)",{"$f":"IF(AVERAGE(C30:C31)<=70,1,IF(AVERAGE(C30:C31)<=90,2,IF(AVERAGE(C30:C31)<=110,3,4)))","v":{"$error":"#DIV/0!"}},{"$f":"IF(AVERAGE(D30:D31)<=60,1,IF(AVERAGE(D30:D31)<=80,2,IF(AVERAGE(D30:D31)<=100,3,4)))","v":{"$error":"#DIV/0!"}},{"$f":"MAX(U30:V30)","v":{"$error":"#DIV/0!"}},{"$f":"MIN(W30:W32)","v":{"$error":"#DIV/0!"}}]
[null,"Up Rearward",null,null,"Static Rating from Sled",null,null,null,{"$f":"MAX(I30:J30)","v":1},null,null,null,{"$f":"MAX(M30:N30)","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"MAX(Q30:R30)","v":{"$error":"#DIV/0!"}},null,null,"Average (DR UF)",{"$f":"IF(AVERAGE(C30,C32)<=70,1,IF(AVERAGE(C30,C32)<=90,2,IF(AVERAGE(C30,C32)<=110,3,4)))","v":{"$error":"#DIV/0!"}},{"$f":"IF(AVERAGE(D30,D32)<=60,1,IF(AVERAGE(D30,D32)<=80,2,IF(AVERAGE(D30,D32)<=100,3,4)))","v":{"$error":"#DIV/0!"}},{"$f":"MAX(U31:V31)","v":{"$error":"#DIV/0!"}},{"$f":"IF(X30>I31,I32&\" Down Rear\",IF(X30=1,\"Good\",IF(X30=2,\"Acceptable\",IF(X30=3,\"Marginal\",\"Poor\"))))","v":{"$error":"#DIV/0!"}}]
[null,"Up Forward",null,null,{"$f":"IF(AND('Seat Set-up'!C27=\"Fixed\",'Seat Set-up'!C28=\"Fixed\"),'HRMD (Full Rear Full Down)'!I32,IF(AND('Seat Set-up'!C27=\"Equipped\",'Seat Set-up'!C28=\"Fixed\"),'HRMD (Full Rear Full Down)'!M32,IF(AND('Seat Set-up'!C27=\"Fixed\",'Seat Set-up'!C28=\"Equipped\"),'HRMD (Full Rear Full Down)'!Q32,IF(AND('Seat Set-up'!C27=\"Equipped\",'Seat Set-up'!C28=\"Equipped\"),'HRMD (Full Rear Full Down)'!X31,\"See Seat Set-up Sheet\"))))","v":"See Seat Set-up Sheet"},null,null,null,{"$f":"IF(I31=1,\"Good\",IF(I31=2,\"Acceptable\",IF(I31=3,\"Marginal\",\"Poor\")))","v":"Good"},null,null,null,{"$f":"IF(M31>I31,I32&\" Down Rear\",IF(M31=1,\"Good\",IF(M31=2,\"Acceptable\",IF(M31=3,\"Marginal\",\"Poor\"))))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(Q31>I31,I32&\" Down Rear\",IF(Q31=1,\"Good\",IF(Q31=2,\"Acceptable\",IF(Q31=3,\"Marginal\",\"Poor\"))))","v":{"$error":"#DIV/0!"}},null,null,"Average (DR DF)",{"$f":"IF(AVERAGE(C30,C33)<=70,1,IF(AVERAGE(C30,C33)<=90,2,IF(AVERAGE(C30,C33)<=110,3,4)))","v":{"$error":"#DIV/0!"}},{"$f":"IF(AVERAGE(D30,D33)<=60,1,IF(AVERAGE(D30,D33)<=80,2,IF(AVERAGE(D30,D33)<=100,3,4)))","v":{"$error":"#DIV/0!"}},{"$f":"MAX(U32:V32)","v":{"$error":"#DIV/0!"}}]
[null,"Down Forward"]
[null,"HRMD by CMM Measurements"]
[]
[null,null,"Horizontal","Vertical"]
[null,"Test Position",{"$f":"IF(C49=\"\",\"\",('Footrest Positioning'!F2)*($C$47-C49))","v":""},{"$f":"IF(E50=\"\",\"\",('Footrest Positioning'!F4)*(E50-$E$48))","v":""}]
[null,"Down Rearward",{"$f":"IF(C51=\"\",\"\",('Footrest Positioning'!F2)*($C$47-C51))","v":""},{"$f":"IF(E52=\"\",\"\",('Footrest Positioning'!F4)*(E52-$E$48))","v":""}]
[null,"Up Rearward",{"$f":"IF(C53=\"\",\"\",('Footrest Positioning'!F2)*($C$47-C53))","v":""},{"$f":"IF(E54=\"\",\"\",('Footrest Positioning'!F4)*(E54-$E$48))","v":""}]
[null,"Up Forward",{"$f":"IF(C55=\"\",\"\",('Footrest Positioning'!F2)*($C$47-C55))","v":""},{"$f":"IF(E56=\"\",\"\",('Footrest Positioning'!F4)*(E56-$E$48))","v":""}]
[null,"Down Forward",{"$f":"IF(C57=\"\",\"\",('Footrest Positioning'!F2)*($C$47-C57))","v":""},{"$f":"IF(E58=\"\",\"\",('Footrest Positioning'!F4)*(E58-$E$48))","v":""}]
[]
[null,null,"X","Y","Z"]
[null,"H-Point (right)",null,null,null,{"$f":"ABS(C44-C45)","v":0}]
[null,"H-Point (left)"]
[null,"Head CG"]
[null,"Horizontal Head"]
[null,"Vertical Head"]
[null,"Test Position horizontal"]
[null,"Test Position vertical"]
[null,"Down Rear horizontal"]
[null,"Down Rear vertical"]
[null,"Up Rear horizontal"]
[null,"Up Rear vertical"]
[null,"Up Forward horizontal"]
[null,"Up Forward vertical"]
[null,"Down Forward horizontal"]
[null,"Down Forward vertical"]
[null,"Center of Recliner"]
[null,"Center of Head Restraint Post"]

{"sheet":"Seat Set-up","index":2,"n_rows":139,"n_cols":29,"rows_kept":139,"cut":false,"hidden":false,"merged":[[8,3,9,3],[24,2,25,2],[24,3,25,3],[0,9,0,12],[0,5,0,8],[0,1,4,4],[8,2,9,2],[132,0,135,0],[56,1,57,1],[52,1,53,1],[8,1,9,1],[95,0,98,0],[107,0,110,0],[24,1,25,1],[32,0,35,0],[45,0,48,0],[46,1,47,1],[33,1,34,1],[37,1,38,1],[40,1,41,1],[62,0,65,0]]}
["Coordinate System",null,null,null,null,"Data Point Collection",null,null,null,"OEM Provided Points"]
[{"$f":"'Footrest Positioning'!A2","v":"X positive forward"},null,null,null,null,"CMM Collection","X (mm)","Y (mm)","Z (mm)","Locations","X (mm)","Y (mm)","Z (mm)"]
[{"$f":"'Footrest Positioning'!A3","v":"Y positive rightward"},null,null,null,null,"Origin (IIHS origin by default)",{"$f":"'Footrest Positioning'!H10","v":0},{"$f":"'Footrest Positioning'!I10","v":0},{"$f":"'Footrest Positioning'!J10","v":0}]
[{"$f":"'Footrest Positioning'!A4","v":"Z positive downward"},null,null,null,null,"Seat Reference Point 2 Rear/Down",null,null,null,"Center recliner (unweighted)"]
[null,null,null,null,null,"Seat Reference Point 2 Forward/Down",null,null,null,"Head restraint post (unweighted)"]
[null,"All coordinates are recorded in mm",null,null,null,"Seat Reference Point 2 Final Position"]
[null,null,null,null,null,"Seat Reference Point 1 Mid/Down",null,null,null,"Target Distances","∆X (mm)","∆Y (mm)","∆Z (mm)"]
["1.2.6.1 Initial seat adjustments",null,null,null,null,"Seat Reference Point 2 Mid/Up",{"$f":"IF($C$14 = \"Fixed\", G6, \"\")","v":""},"","","LF seat bolt → Center recliner",{"$f":"IF(K4 = \"\", \"\", ABS('Footrest Positioning'!L3-K4))","v":""},{"$f":"IF(L4 = \"\", \"\", ABS('Footrest Positioning'!M3-L4))","v":""},{"$f":"IF(M4 = \"\", \"\", ABS('Footrest Positioning'!N3-M4))","v":""}]
[null,"Seat Adjustments","Type","Position for Testing",null,"Seat Reference Point 1 Mid/Up","","","","Center recliner → HR post",{"$f":"IF(K5=\"\",\"\",ABS(K4-K5))","v":""},{"$f":"IF(L5=\"\",\"\",ABS(L4-L5))","v":""},""]
[null,null,null,null,null,"Seat Reference Point 2 Final Position"]
[null,"Material",null,null,null,"Seat Reference Point 1 Final Position",null,null,null,"Actual Distances","∆X (mm)","∆Y (mm)","∆Z (mm)"]
[null,"Track",null,{"$f":"IF(C12=\"Fixed\",\"N/A\",IF(OR(C12=\"Manual\",C12=\"Electric\"),\"Mid\",\"\"))","v":""},null,"Head Restraint Post Pt. 1",null,null,null,"LF seat bolt → Center recliner",{"$f":"IF(G10 = \"\", \"\", ABS('Footrest Positioning'!C12-C60))","v":""},{"$f":"IF(H10 = \"\", \"\", ABS('Footrest Positioning'!D12-D60))","v":""},{"$f":"IF(I10 = \"\", \"\", ABS('Footrest Positioning'!E11-E60))","v":""},null,null,{"$f":"G13 - G12","v":0},{"$f":"H13 - H12","v":0},{"$f":"I13 - I12","v":0},{"$f":"P12^2 + Q12^2 + R12^2","v":0},{"$f":"Q13*R14 - R13*Q14","v":0},{"$f":"R13*P14 - P13*R14","v":0},{"$f":"P13*Q14 - Q13*P14","v":0},{"$f":"S12*T12 + S13*T13","v":0},{"$f":"S12*U12 + S13*U13","v":0},{"$f":"S12*V12 + S13*V13","v":0},{"$f":"2*S14","v":0},{"$f":"W12/Z12","v":{"$error":"#DIV/0!"}},{"$f":"X12/Z12","v":{"$error":"#DIV/0!"}},{"$f":"Y12/Z12","v":{"$error":"#DIV/0!"}}]
[null,"Seat back",null,{"$f":"IF(C13=\"Fixed\",\"N/A\",IF(OR(C13=\"Manual\",C13=\"Electric\"),\"Nominal\",\"\"))","v":""},null,"Head Restraint Post Pt. 2",null,null,null,"Center recliner → HR post",{"$f":"IF(G15 = \"\", \"\", ABS(C60-C68))","v":""},{"$f":"IF(H15 = \"\", \"\", ABS(D60-D68))","v":""},{"$f":"IF(I15 = \"\", \"\", ABS(E60-E68))","v":""},null,null,{"$f":"G14 - G12","v":0},{"$f":"H14 - H12","v":0},{"$f":"I14 - I12","v":0},{"$f":"P13^2 + Q13^2 + R13^2","v":0},{"$f":"Q14*R12 - R14*Q12","v":0},{"$f":"R14*P12 - P14*R12","v":0},{"$f":"P14*Q12 - Q14*P12","v":0}]
[null,"Seat height",null,{"$f":"IF(C14=\"Fixed\",\"N/A\",IF(OR(C14=\"Manual, 2-way\",C14=\"Manual, 4-way\",C14=\"Electric, 2-way\",C14=\"Electric, 4-way\"),\"Mid\",\"\"))","v":""},null,"Head Restraint Post Pt. 3",null,null,null,null,null,null,null,null,null,{"$f":"Q12*R13 - R12*Q13","v":0},{"$f":"R12*P13 - P12*R13","v":0},{"$f":"P12*Q13 - Q12*P13","v":0},{"$f":"P14^2 + Q14^2 + R14^2","v":0}]
[null,"Seat tilt",null,{"$f":"IF(C15=\"Fixed\",\"N/A\",IF(OR(C15=\"Manual\",C15=\"Electric\"),\"Off\",\"\"))","v":""},null,"Center of Head Restraint Post",{"$f":"IF(G12=\"\", \"\", IF(AND(G13=\"\",G14=\"\"), G12, IF(G14=\"\", \"Take Pt.3\", P15)))","v":""},{"$f":"IF(H12=\"\", \"\", IF(AND(H13=\"\",H14=\"\"), H12, IF(H14=\"\", \"Take Pt.3\", Q15)))","v":""},"",null,null,null,null,null,null,{"$f":"G12 + AA12","v":{"$error":"#DIV/0!"}},{"$f":"H12 + AB12","v":{"$error":"#DIV/0!"}},{"$f":"I12 + AC12","v":{"$error":"#DIV/0!"}}]
[null,"Seat cushion height",null,{"$f":"IF(C16=\"Fixed\",\"N/A\",IF(OR(C16=\"Manual, 2-way\",C16=\"Manual, 4-way\",C16=\"Electric, 2-way\",C16=\"Electric, 4-way\"),\"Mid\",\"\"))","v":""},null,"Cushion Point 1 Full Down"]
[null,"Seat cushion tilt",null,{"$f":"IF(C17=\"Fixed\",\"N/A\",IF(OR(C17=\"Manual\",C17=\"Electric\"),\"Off\",\"\"))","v":""},null,"Cushion Point 2 Full Down"]
[null,"Lumbar",null,{"$f":"IF(C18=\"Fixed\",\"N/A\",IF(OR(C18=\"Manual\",C18=\"Electric\"),\"Off\",\"\"))","v":""},null,"Cushion Point 2 Full Up"]
[null,"Upper seat back of a two point articulating seat back",null,{"$f":"IF(C19=\"Fixed\",\"N/A\",IF(OR(C19=\"Manual\",C19=\"Electric\"),\"Mid\",\"\"))","v":""},null,"Cushion Point 2 Mid Position"]
[null,"Cushion Extension",null,{"$f":"IF(C20=\"Fixed\",\"N/A\",IF(OR(C20=\"Manual\",C20=\"Electric\"),\"Off\",\"\"))","v":""},null,"Cushion Point 1 Full Down"]
[null,"Side Bolster",null,{"$f":"IF(C21=\"Fixed\",\"N/A\",IF(OR(C21=\"Manual\",C21=\"Electric\"),\"Off\",\"\"))","v":""},null,"Cushion Point 2 Full Down"]
[null,"Heated",null,null,null,"Cushion Point 2 Full Up"]
[null,"Seat mounted side airbags",null,null,null,"Cushion Point 2 Mid Position"]
[null,null,null,null,null,"Cushion Point 1 "]
[null,"Head Restraint Adjustments","Type",null,null,"Cushion Point 2 "]
[null,null,null,null,null,"Measurements","Value","Units"]
[null,"Height Lock",null,null,null,"Upper seat back rotated fully rearward",null,"degrees"]
[null,"Tilt Lock",null,null,null,"Upper seat back rotated fully forward",null,"degrees"]
[null,"Anti-whiplash mechanism",null,null,null,"Actual mid position",null,"degrees"]
[]
[]
[]
["1.2.6.3 Define seat travel range - TRACK",null,"X","Y","Z"]
[null,"Initial Position"]
[]
[null,"Seat Reference Point 2 Rear/Down",{"$f":"G4-$G$3","v":0},{"$f":"H4-$H$3","v":0},{"$f":"I4-$I$3","v":0}]
[null,"Seat Reference Point 2 Forward/Down",{"$f":"G5-$G$3","v":0},{"$f":"H5-$H$3","v":0},{"$f":"I5-$I$3","v":0}]
[null,"Target Position"]
[]
[null,"Seat Reference Point 2 Calculated Mid Position",{"$f":"AVERAGE(C36:C37)","v":0}]
[null,"Final Position"]
[]
[null,"Seat Reference Point 2 Final Position",{"$f":"G6-$G$3","v":0},{"$f":"H6-$H$3","v":0},{"$f":"I6-$I$3","v":0}]
[null,"Tolerance Reference Point 2",{"$f":"IF(OR(C12=\"\",C43=\"\"),\"\",IF(AND(C12=\"Electric\",(OR('Footrest Positioning'!F2*C43<'Footrest Positioning'!F2*C40-2,'Footrest Positioning'!F2*C43>'Footrest Positioning'!F2*C40+2))),\"Out of tolerance\",IF(AND(C12=\"Manual\",'Footrest Positioning'!F2*C43>'Footrest Positioning'!F2*C40+2),\"Move one notch rearward\",\"Good\")))","v":""}]
[]
["1.2.6.4 Define seat travel range - HEIGHT",null,"X","Y","Z"]
[null,"Initial Position"]
[]
[null,"Seat Reference Point 1 Mid/Down",{"$f":"G7-$G$3","v":0},{"$f":"H7-$H$3","v":0},{"$f":"I7-$I$3","v":0}]
[null,"Seat Reference Point 2 Mid/Down",{"$f":"G6-$G$3","v":0},{"$f":"H6-$H$3","v":0},{"$f":"I6-$I$3","v":0}]
[null,"Seat Reference Point 2 Mid/Up",{"$f":"G8-$G$3","v":{"$error":"#VALUE!"}},{"$f":"H8-$H$3","v":{"$error":"#VALUE!"}},{"$f":"I8-$I$3","v":{"$error":"#VALUE!"}}]
[null,"Seat Reference Point 1 Mid/Up",{"$f":"G9-$G$3","v":{"$error":"#VALUE!"}},{"$f":"H9-$H$3","v":{"$error":"#VALUE!"}},{"$f":"I9-$I$3","v":{"$error":"#VALUE!"}}]
[null,"Target Position"]
[]
[null,"Seat Reference Point 1 Calculated Mid Position",{"$f":"AVERAGE(C49,C52)","v":{"$error":"#VALUE!"}},null,{"$f":"AVERAGE(E49,E52)","v":{"$error":"#VALUE!"}}]
[null,"Seat Reference Point 2 Calculated Mid Position",{"$f":"AVERAGE(C50,C51)","v":{"$error":"#VALUE!"}},null,{"$f":"AVERAGE(E50,E51)","v":{"$error":"#VALUE!"}}]
[null,"Final Position"]
[]
[null,"Seat Reference Point 1 Final Position",{"$f":"G11-$G$3","v":0},{"$f":"H11-$H$3","v":0},{"$f":"I11-$I$3","v":0}]
[null,"Seat Reference Point 2 Final Position",{"$f":"G10-$G$3","v":0},{"$f":"H10-$H$3","v":0},{"$f":"I10-$I$3","v":0}]
[null,"Tolerance Reference Point 1",null,null,{"$f":"IF(OR(C14=\"\",E59=\"\"),\"\",IF(AND(C14=\"Electric, 4-way\",(OR('Footrest Positioning'!F4*E59<'Footrest Positioning'!F4*E55-2,'Footrest Positioning'!F4*E59>'Footrest Positioning'!F4*E55+2))),\"Out of tolerance\",IF(AND(C14=\"Manual, 4-way\",'Footrest Positioning'!F4*E59<'Footrest Positioning'!F4*E55-2),\"Move one notch lower\",\"Good\")))","v":""}]
[null,"Tolerance Reference Point 2",null,null,{"$f":"IF(OR(C14=\"\",E60=\"\"),\"\",IF(AND(C14=\"Electric, 2-way\",(OR('Footrest Positioning'!F4*E60<'Footrest Positioning'!F4*E56-2,'Footrest Positioning'!F4*E60>'Footrest Positioning'!F4*E56+2))),\"Out of tolerance\",IF(AND(C14=\"Electric, 4-way\",(OR('Footrest Positioning'!F4*E60<'Footrest Positioning'!F4*E56-2,'Footrest Positioning'!F4*E60>'Footrest Positioning'!F4*E56+2))),\"Out of tolerance\",IF(AND(C14=\"Manual, 2-way\",'Footrest Positioning'!F4*E60<'Footrest Positioning'!F4*E56-2),\"Move one notch lower\",IF(AND(C14=\"Manual, 4-way\",'Footrest Positioning'!F4*E60<'Footrest Positioning'!F4*E56-2),\"Move one notch lower\",\"Good\")))))","v":""}]
["1.2.6.8 Set initial seatback angle","Target Position"]
[null,"Center of Recliner (unweighted)",{"$f":"IF(K8 = \"\", \"\", 'Footrest Positioning'!C12-'Footrest Positioning'!F2*K8)","v":""},{"$f":"IF(L8=\"\",\"\",IF(ABS('Footrest Positioning'!M3)>ABS(L4),'Footrest Positioning'!D12+'Footrest Positioning'!F3*L8,'Footrest Positioning'!D12-'Footrest Positioning'!F3*L8))","v":""},{"$f":"IF(M8 = \"\", \"\", 'Footrest Positioning'!E11-'Footrest Positioning'!F4*M8)","v":""}]
[null,"Center of Head Restraint Post (unweighted)",{"$f":"IF(C64 = \"\", \"\", C64 - 'Footrest Positioning'!F2*K9)","v":""},{"$f":"IF(D64 = \"\", \"\", D64 + 'Footrest Positioning'!F3*L9)","v":""},{"$f":"IF(E64 = \"\", \"\", E64 - 'Footrest Positioning'!F4*M9)","v":""}]
[null,"Final Position"]
[null,"Center of Recliner (unweighted)",{"$f":"IF(G10=\"\", \"\", G10-$G$3)","v":""},{"$f":"IF(H10=\"\", \"\", H10-$H$3)","v":""},{"$f":"IF(I10=\"\", \"\", I10-$I$3)","v":""}]
[null,"Center of Head Restraint Post (unweighted)",{"$f":"IF(G15=\"\", \"\", G15-$G$3)","v":""},{"$f":"IF(H15=\"\", \"\", H15-$H$3)","v":""},{"$f":"IF(I15=\"\", \"\", I15-$I$3)","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"IF(OR(C16=\"Fixed\",C16=\"Unknown\"),\"THIS SECTION DOES NOT APPLY TO THIS SEAT. CONTINUE TO NEXT SECTION.\",\"\")","v":""}]
["1.2.6.5 Define seat cushion height adjustment range                SINGLE CONTROL",null,"X","Y","Z"]
[null,"Initial Position"]
[null,"Cushion Point 1 Full Down",{"$f":"G16-$G$3","v":0},{"$f":"H16-$H$3","v":0},{"$f":"I16-$I$3","v":0}]
[null,"Cushion Point 2 Full Down",{"$f":"G17-$G$3","v":0},{"$f":"H17-$H$3","v":0},{"$f":"I17-$I$3","v":0}]
[null,"Cushion Point 2 Full Down Target",{"$f":"C98-400","v":-400}]
[null,"Cushion Point 2 Full Up",{"$f":"G18-$G$3","v":0},{"$f":"H18-$H$3","v":0},{"$f":"I18-$I$3","v":0}]
[null,"Target Calculations"]
[null,"Cushion Point 2 Calculated Mid Position",null,null,{"$f":"AVERAGE(E99,E101)","v":0}]
[null,"Final Position"]
[null,"Cushion Point 2 Mid Position",{"$f":"G19-$G$3","v":0},{"$f":"H19-$H$3","v":0},{"$f":"I19-$I$3","v":0}]
[null,"Tolerance Cushion Point 2",null,null,{"$f":"IF(E105=\"\",\"\",IF(OR('Footrest Positioning'!F4*E105<'Footrest Positioning'!F4*E103-2,'Footrest Positioning'!F4*E105>'Footrest Positioning'!F4*E103+2),\"Out of tolerance\",\"Good\"))","v":"Good"}]
[]
["1.2.6.5 Define seat cushion height adjustment range                MULTIPLE CONTROLS",null,"X","Y","Z"]
[null,"Initial Position"]
[null,"Cushion Point 1 Full Down",{"$f":"G20-$G$3","v":0},{"$f":"H20-$H$3","v":0},{"$f":"I20-$I$3","v":0}]
[null,"Cushion Point 2 Full Down",{"$f":"G21-$G$3","v":0},{"$f":"H21-$H$3","v":0},{"$f":"I21-$I$3","v":0}]
[null,"Cushion Point 2 Full Down Target",{"$f":"C110-400","v":-400}]
[null,"Cushion Point 2 Full Up",{"$f":"G22-$G$3","v":0},{"$f":"H22-$H$3","v":0},{"$f":"I22-$I$3","v":0}]
[null,"Target Calculations"]
[null,"Cushion Point 2 Calculated Mid Position",null,null,{"$f":"AVERAGE(E111,E113)","v":0}]
[null,"Final Position"]
[null,"Cushion Point 2 Mid Position",{"$f":"G23-$G$3","v":0},{"$f":"H23-$H$3","v":0},{"$f":"I23-$I$3","v":0}]
[null,"Tolerance Cushion Point 2",null,null,{"$f":"IF(E117=\"\",\"\",IF(OR('Footrest Positioning'!F4*E117<'Footrest Positioning'!F4*E115-2,'Footrest Positioning'!F4*E117>'Footrest Positioning'!F4*E115+2),\"Out of tolerance\",\"Good\"))","v":"Good"}]
[null,"Adjusted Position"]
[null,"Cushion Point 1 ",{"$f":"G24-$G$3","v":0},{"$f":"H24-$H$3","v":0},{"$f":"I24-$I$3","v":0}]
[null,"Cushion Point 2 ",{"$f":"G25-$G$3","v":0},{"$f":"H25-$H$3","v":0},{"$f":"I25-$I$3","v":0}]
[null,"Seat Cushion Angle",{"$f":"DEGREES(ATAN(ABS(E120-E121)/ABS(C120-C121)))","v":{"$error":"#DIV/0!"}}]
[null,"Tolerance Seat Cushion Angle",{"$f":"IF(C120=\"\",\"\",IF(OR(C122<C124-0.5,C122>C124+0.5),\"Out of tolerance\",\"Good\"))","v":{"$error":"#DIV/0!"}}]
[null,"Seat Cushion Angle Target",{"$f":"DEGREES(ATAN(ABS(E110-E111)/ABS(C110-C111)))","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"IF(OR(C19=\"Fixed\",C19=\"Unknown\"),\"THIS SECTION DOES NOT APPLY TO THIS SEAT.\",\"\")","v":""}]
["1.2.6.6 Upper seat back of a two point articulating seat back adjustment range",null,"Angle"]
[]
[null,"Upper seat back rotated fully rearward",{"$f":"G27","v":0}]
[null,"Upper seat back rotated fully forward",{"$f":"G28","v":0}]
[]
[null,"Calculated mid position",{"$f":"AVERAGE(C135:C136)","v":0}]
[null,"Actual mid position",{"$f":"G29","v":0}]

{"sheet":"Head Restraint Position","index":3,"n_rows":84,"n_cols":17,"rows_kept":84,"cut":false,"hidden":false,"merged":[[80,1,81,1],[82,2,82,3],[82,4,82,5],[0,1,4,4],[8,1,9,1],[25,1,26,1],[76,1,77,1],[42,1,43,1],[59,1,60,1],[0,6,0,9],[83,2,83,3],[83,4,83,5],[78,2,78,3],[78,4,78,5],[79,2,79,3],[79,4,79,5]]}
["Coordinate System",null,null,null,null,null,"Data Point Collection",null,null,null,null,null,null,"Select New Position","Select New Position","Select New Position","Select New Position"]
[{"$f":"'Footrest Positioning'!A2","v":"X positive forward"},null,null,null,null,null,"CMM Collection","X (mm)","Y (mm)","Z (mm)",null,null,null,"1st position"," of 1 vertical position","1st position"," of 1 horizontal position"]
[{"$f":"'Footrest Positioning'!A3","v":"Y positive rightward"},null,null,null,null,null,"Origin (IIHS origin by default)",{"$f":"'Footrest Positioning'!H10","v":0},{"$f":"'Footrest Positioning'!I10","v":0},{"$f":"'Footrest Positioning'!J10","v":0},null,null,null,"2nd position"," of 2 vertical positions","2nd position"," of 2 horizontal positions"]
[{"$f":"'Footrest Positioning'!A4","v":"Z positive downward"},null,null,null,null,null,{"$f":"_xlfn.LET( _xlpm.Vertical1, B11:B23, _xlpm.Vertical2, B28:B40, _xlpm.Vertical3, B42, _xlpm.Horiz1, B45:B57, _xlpm.Horiz2, B62:B74, _xlpm.Horiz3, B76, _xlpm.Combined, _xlfn.VSTACK(_xlpm.Vertical1, _xlpm.Vertical2, _xlpm.Vertical3, _xlpm.Horiz1, _xlpm.Horiz2, _xlpm.Horiz3), _xlpm.NonBlanks, _xlfn._xlws.FILTER(_xlpm.Combined, _xlpm.Combined<>\"\"), _xlpm.NonBlanks )","v":"Full Down"},null,null,null,null,null,null,"3rd position"," of 3 vertical positions","3rd position"," of 3 horizontal positions"]
[null,null,null,null,null,null,"Full Down (verified)",null,null,null,null,null,null,"4th position"," of 4 vertical positions","4th position"," of 4 horizontal positions"]
[null,"All coordinates are recorded in mm",null,null,null,null,"Test Position - Vertical",null,null,null,null,null,null,"5th position"," of 5 vertical positions","5th position"," of 5 horizontal positions"]
[null,null,null,null,null,null,"Full Rear",null,null,null,null,null,null,"6th position"," of 6 vertical positions","6th position"," of 6 horizontal positions"]
["1.2.6.9 Head Restraint Test Position",null,"X","Y","Z",null,"Full Rear (verified)",null,null,null,null,null,null,"7th position"," of 7 vertical positions","7th position","of 7 horizontal positions"]
[null,"Head Restraint Test Position - Vertical",null,null,null,null,"Test Position - Horizontal",null,null,null,null,null,null,"8th position"," of 8 vertical positions","8th position","of 8 horizontal positions"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"9th position"," of 9 vertical positions","9th position","of 9 horizontal positions"]
[null,"Full Down",{"$f":"IF(AND(B11<>\"\", NOT(ISNA(MATCH(B11, G$4:G$57, 0)))), INDEX(H$4:H$57, MATCH(B11, G$4:G$57, 0)) - H$3, \"\")","v":0},{"$f":"IF(AND(B11<>\"\", NOT(ISNA(MATCH(B11, G$4:G$57, 0)))), INDEX(I$4:I$57, MATCH(B11, G$4:G$57, 0)) - I$3, \"\")","v":0},{"$f":"IF(AND(B11<>\"\", NOT(ISNA(MATCH(B11, G$4:G$57, 0)))), INDEX(J$4:J$57, MATCH(B11, G$4:G$57, 0)) - J$3, \"\")","v":0},null,null,null,null,null,null,null,null,"10th position"," of 10 vertical positions","10th position","of 10 horizontal positions"]
[null,null,{"$f":"IF(AND(B12<>\"\", NOT(ISNA(MATCH(B12, G$4:G$57, 0)))), INDEX(H$4:H$57, MATCH(B12, G$4:G$57, 0)) - H$3, \"\")","v":""},{"$f":"IF(AND(B12<>\"\", NOT(ISNA(MATCH(B12, G$4:G$57, 0)))), INDEX(I$4:I$57, MATCH(B12, G$4:G$57, 0)) - I$3, \"\")","v":""},{"$f":"IF(AND(B12<>\"\", NOT(ISNA(MATCH(B12, G$4:G$57, 0)))), INDEX(J$4:J$57, MATCH(B12, G$4:G$57, 0)) - J$3, \"\")","v":""},{"$f":"IF(E12=\"\",\"\",ABS(E11-E12))","v":""},null,null,null,null,null,null,null,"11th position"," of 11 vertical positions","11th position","of 11 horizontal positions"]
[null,null,"","","","",null,null,null,null,null,null,null,"12th position"," of 12 vertical positions","12th position","of 12 horizontal positions"]
[null,null,"","","","",null,null,null,null,null,null,null,"13th position"," of 13 vertical positions","13th position","of 13 horizontal positions"]
[null,null,"","","",""]
[null,null,"","","",""]
[null,null,"","","",""]
[null,null,"","","",""]
[null,null,"","","",""]
[null,null,"","","",""]
[null,null,"","","",""]
[null,null,"","","",""]
[null,null,"","","",""]
[null,"Calculated Geometric Midpoint"]
[]
[null,"Head Restraint Test Position (verified) - Vertical"]
[]
[null,"Full Down (verified)",{"$f":"IF(AND(B28<>\"\", NOT(ISNA(MATCH(B28, G$4:G$57, 0)))), INDEX(H$4:H$57, MATCH(B28, G$4:G$57, 0)) - H$3, \"\")","v":0},{"$f":"IF(AND(B28<>\"\", NOT(ISNA(MATCH(B28, G$4:G$57, 0)))), INDEX(I$4:I$57, MATCH(B28, G$4:G$57, 0)) - I$3, \"\")","v":0},{"$f":"IF(AND(B28<>\"\", NOT(ISNA(MATCH(B28, G$4:G$57, 0)))), INDEX(J$4:J$57, MATCH(B28, G$4:G$57, 0)) - J$3, \"\")","v":0}]
[null,{"$f":"IF(B12=\"\",\"\",_xlfn.CONCAT(B12,\" (verified)\"))","v":""},{"$f":"IF(AND(B29<>\"\", NOT(ISNA(MATCH(B29, G$4:G$57, 0)))), INDEX(H$4:H$57, MATCH(B29, G$4:G$57, 0)) - H$3, \"\")","v":""},{"$f":"IF(AND(B29<>\"\", NOT(ISNA(MATCH(B29, G$4:G$57, 0)))), INDEX(I$4:I$57, MATCH(B29, G$4:G$57, 0)) - I$3, \"\")","v":""},{"$f":"IF(AND(B29<>\"\", NOT(ISNA(MATCH(B29, G$4:G$57, 0)))), INDEX(J$4:J$57, MATCH(B29, G$4:G$57, 0)) - J$3, \"\")","v":""},{"$f":"IF(E29=\"\",\"\",ABS(E28-E29))","v":""}]
[null,{"$f":"IF(B13=\"\",\"\",_xlfn.CONCAT(B13,\" (verified)\"))","v":""},"","","",""]
[null,"","","","",""]
[null,"","","","",""]
[null,"","","","",""]
[null,"","","","",""]
[null,"","","","",""]
[null,"","","","",""]
[null,"","","","",""]
[null,"","","","",""]
[null,"","","","",""]
[null,"","","","",""]
[null,"Calculated Geometric Midpoint"]
[null,"Test Position - Vertical",{"$f":"IF(AND(B42<>\"\", NOT(ISNA(MATCH(B42, G$4:G$57, 0)))), INDEX(H$4:H$57, MATCH(B42, G$4:G$57, 0)) - H$3, \"\")","v":0},{"$f":"IF(AND(B42<>\"\", NOT(ISNA(MATCH(B42, G$4:G$57, 0)))), INDEX(I$4:I$57, MATCH(B42, G$4:G$57, 0)) - I$3, \"\")","v":0},{"$f":"IF(AND(B42<>\"\", NOT(ISNA(MATCH(B42, G$4:G$57, 0)))), INDEX(J$4:J$57, MATCH(B42, G$4:G$57, 0)) - J$3, \"\")","v":0}]
[null,"Head Restraint Test Position - Horizontal"]
[]
[null,"Full Rear",{"$f":"IF(AND(B45<>\"\", NOT(ISNA(MATCH(B45, G$4:G$57, 0)))), INDEX(H$4:H$57, MATCH(B45, G$4:G$57, 0)) - H$3, \"\")","v":0},{"$f":"IF(AND(B45<>\"\", NOT(ISNA(MATCH(B45, G$4:G$57, 0)))), INDEX(I$4:I$57, MATCH(B45, G$4:G$57, 0)) - I$3, \"\")","v":0},{"$f":"IF(AND(B45<>\"\", NOT(ISNA(MATCH(B45, G$4:G$57, 0)))), INDEX(J$4:J$57, MATCH(B45, G$4:G$57, 0)) - J$3, \"\")","v":0}]
[null,null,{"$f":"IF(AND(B46<>\"\", NOT(ISNA(MATCH(B46, G$4:G$57, 0)))), INDEX(H$4:H$57, MATCH(B46, G$4:G$57, 0)) - H$3, \"\")","v":""},{"$f":"IF(AND(B46<>\"\", NOT(ISNA(MATCH(B46, G$4:G$57, 0)))), INDEX(I$4:I$57, MATCH(B46, G$4:G$57, 0)) - I$3, \"\")","v":""},{"$f":"IF(AND(B46<>\"\", NOT(ISNA(MATCH(B46, G$4:G$57, 0)))), INDEX(J$4:J$57, MATCH(B46, G$4:G$57, 0)) - J$3, \"\")","v":""},{"$f":"IF(C46=\"\",\"\",ABS(C45-C46))","v":""}]
[null,null,"","","",{"$f":"IF(C47=\"\",\"\",ABS(C46-C47))","v":""}]
[null,null,"","","",{"$f":"IF(C48=\"\",\"\",ABS(C47-C48))","v":""}]
[null,null,"","","",{"$f":"IF(C49=\"\",\"\",ABS(C48-C49))","v":""}]
[null,null,"","","",""]
[null,null,"","","",""]
[null,null,"","","",""]
[null,null,"","","",""]
[null,null,"","","",""]
[null,null,"","","",""]
[null,null,"","","",""]
[null,null,"",null,"",""]
[null,"Calculated Geometric Midpoint"]
[]
[null,"Head Restraint Test Position (verified) - Horizontal"]
[]
[null,"Full Rear (verified)",{"$f":"IF(AND(B62<>\"\", NOT(ISNA(MATCH(B62, G$4:G$57, 0)))), INDEX(H$4:H$57, MATCH(B62, G$4:G$57, 0)) - H$3, \"\")","v":0},{"$f":"IF(AND(B62<>\"\", NOT(ISNA(MATCH(B62, G$4:G$57, 0)))), INDEX(I$4:I$57, MATCH(B62, G$4:G$57, 0)) - I$3, \"\")","v":0},{"$f":"IF(AND(B62<>\"\", NOT(ISNA(MATCH(B62, G$4:G$57, 0)))), INDEX(J$4:J$57, MATCH(B62, G$4:G$57, 0)) - J$3, \"\")","v":0}]
[null,{"$f":"IF(B46=\"\",\"\",_xlfn.CONCAT(B46, \" (verified)\"))","v":""},{"$f":"IF(AND(B63<>\"\", NOT(ISNA(MATCH(B63, G$4:G$57, 0)))), INDEX(H$4:H$57, MATCH(B63, G$4:G$57, 0)) - H$3, \"\")","v":""},{"$f":"IF(AND(B63<>\"\", NOT(ISNA(MATCH(B63, G$4:G$57, 0)))), INDEX(I$4:I$57, MATCH(B63, G$4:G$57, 0)) - I$3, \"\")","v":""},{"$f":"IF(AND(B63<>\"\", NOT(ISNA(MATCH(B63, G$4:G$57, 0)))), INDEX(J$4:J$57, MATCH(B63, G$4:G$57, 0)) - J$3, \"\")","v":""},{"$f":"IF(C63=\"\",\"\",ABS(C62-C63))","v":""}]
[null,{"$f":"IF(B47=\"\",\"\",_xlfn.CONCAT(B47, \" (verified)\"))","v":""},"","","",{"$f":"IF(C64=\"\",\"\",ABS(C63-C64))","v":""}]
[null,"","","","",{"$f":"IF(C65=\"\",\"\",ABS(C64-C65))","v":""}]
[null,"","","","",""]
[null,"","","","",""]
[null,"","","","",""]
[null,"","","","",""]
[null,"","","","",""]
[null,"","","","",""]
[null,"","","","",""]
[null,"","","","",""]
[null,"","","","",""]
[null,"Calculated Geometric Midpoint"]
[null,"Test Position - Horizontal",{"$f":"IF(AND(B76<>\"\", NOT(ISNA(MATCH(B76, G$4:G$57, 0)))), INDEX(H$4:H$57, MATCH(B76, G$4:G$57, 0)) - H$3, \"\")","v":0},{"$f":"IF(AND(B76<>\"\", NOT(ISNA(MATCH(B76, G$4:G$57, 0)))), INDEX(I$4:I$57, MATCH(B76, G$4:G$57, 0)) - I$3, \"\")","v":0},{"$f":"IF(AND(B76<>\"\", NOT(ISNA(MATCH(B76, G$4:G$57, 0)))), INDEX(J$4:J$57, MATCH(B76, G$4:G$57, 0)) - J$3, \"\")","v":0}]
[null,"Head Restraint Position (original)"]
[]
[null,"HR \"Test Position\" Height Adjustment Description"]
[null,"HR \"Test Position\" Tilt Adjustment Description"]
[null,"Head Restraint Position (actual)"]
[]
[null,"HR \"Test Position\" Height Adjustment Description","Select New Position",null,"Select New Position"]
[null,"HR \"Test Position\" Tilt Adjustment Description",{"$f":"IF(C80=\"Fixed\",\"Fixed\",\"Select New Position\")","v":"Select New Position"},null,{"$f":"IF(C84=\"Fixed\",\"\",\"Select New Position\")","v":"Select New Position"}]

{"sheet":"HRMD","index":4,"n_rows":58,"n_cols":30,"rows_kept":58,"cut":false,"hidden":false,"merged":[[52,0,53,0],[10,2,10,4],[54,0,57,0],[0,10,0,13],[50,0,51,0],[0,6,0,9],[13,1,14,1],[0,1,4,4],[8,1,9,1],[25,1,26,1],[35,5,36,5],[16,4,16,5],[18,1,19,1],[17,2,17,3],[17,4,17,5],[16,2,16,3],[12,2,12,4],[11,2,11,4]]}
["Coordinate System",null,null,null,null,null,"Data Point Collection",null,null,null,"OEM Provided Points"]
[{"$f":"'Footrest Positioning'!A2","v":"X positive forward"},null,null,null,null,null,"Measurements","Value","Units",null,"Locations","X (mm)","Y (mm)","Z (mm)"]
[{"$f":"'Footrest Positioning'!A3","v":"Y positive rightward"},null,null,null,null,null,"Seatback Angle (unweighted)",null,"degrees"]
[{"$f":"'Footrest Positioning'!A4","v":"Z positive downward"},null,null,null,null,null,"Torso Angle",null,"degrees",null,"Center recliner (weighted)"]
[null,null,null,null,null,null,"Seatback Angle (weighted)",null,"degrees",null,"Head restraint post (weighted)"]
[null,"All coordinates are recorded in mm",null,null,null,null,"Thigh Angle",null,"degrees"]
[null,null,null,null,null,null,null,null,null,null,"Target Distances","∆X (mm)","∆Y (mm)","∆Z (mm)"]
["1.3.2 H-point manikin installation",null,null,null,null,null,"CMM Collection","X (mm)","Y (mm)","Z (mm)","LF seat bolt → Center recliner",{"$f":"IF(L4 = \"\", \"\", ABS('Footrest Positioning'!L3-L4))","v":""},{"$f":"IF(M4 = \"\", \"\", ABS('Footrest Positioning'!M3-M4))","v":""},{"$f":"IF(N4 = \"\", \"\", ABS('Footrest Positioning'!N3-N4))","v":""}]
[null,"Test Information",null,null,null,null,"Origin (IIHS origin by default)",{"$f":"'Footrest Positioning'!H10","v":0},{"$f":"'Footrest Positioning'!I10","v":0},{"$f":"'Footrest Positioning'!J10","v":0},"Center recliner → HR post",{"$f":"IF(L5=\"\",\"\",ABS(L4-L5))","v":""},{"$f":"IF(M5=\"\",\"\",ABS(M4-M5))","v":""},""]
[null,null,null,null,null,null,"H-Point (right)"]
[null,"Test ID",null,null,null,null,"H-Point (left)",null,null,null,"Actual Distances","∆X (mm)","∆Y (mm)","∆Z (mm)"]
[null,"Year/Make/Model",null,null,null,null,"Test Position horizontal",null,null,null,"LF seat bolt → Center recliner",{"$f":"IF(H18 = \"\", \"\", ABS('Footrest Positioning'!C12-C51))","v":""},{"$f":"IF(I18 = \"\", \"\", ABS('Footrest Positioning'!D12-D51))","v":""},{"$f":"IF(J18 = \"\", \"\", ABS('Footrest Positioning'!E11-E51))","v":""}]
[null,"Seat Positioning Procedure","Version 3.0",null,null,null,"Test Position vertical",null,null,null,"Center recliner → HR post",{"$f":"IF(H17 = \"\", \"\", ABS(C51-C52))","v":""},{"$f":"IF(I17 = \"\", \"\", ABS(D51-D52))","v":""},{"$f":"IF(J17 = \"\", \"\", ABS(E51-E52))","v":""}]
[null,"Seat Information",null,null,null,null,"Head Restraint Post Pt. 1"]
[null,null,"Weighted","Unweighted",null,"Thigh Angle","Head Restraint Post Pt. 2"]
[null,"Seatback Angle",{"$f":"H5","v":0},{"$f":"H3","v":0},null,{"$f":"H6","v":0},"Head Restraint Post Pt. 3"]
[null,"HR \"Test Position\" Height Adjustment Description",null,null,null,null,"Center of Head Restraint Post",{"$f":"IF(H14=\"\", \"\", AVERAGE(H14:H16))","v":""},{"$f":"IF(I14=\"\", \"\", AVERAGE(I14:I16))","v":""},""]
[null,"HR \"Test Position\" Tilt Adjustment Description",null,null,null,null,"Center of Recliner"]
[null,"HRMD Information",null,null,null,null,"Test Position horizontal (unweighted)"]
[null,null,null,null,null,null,"Test Position vertical (unweighted)"]
[null,"Right Leg",5,null,null,null,"Head Restraint Post Pt. 1 (unweighted)",null,null,null,null,null,null,null,null,null,{"$f":"H22 - H21","v":0},{"$f":"I22 - I21","v":0},{"$f":"J22 - J21","v":0},{"$f":"Q21^2 + R21^2 + S21^2","v":0},{"$f":"R22*S23 - S22*R23","v":0},{"$f":"S22*Q23 - Q22*S23","v":0},{"$f":"Q22*R23 - R22*Q23","v":0},{"$f":"T21*U21 + T22*U22","v":0},{"$f":"T21*V21 + T22*V22","v":0},{"$f":"T21*W21 + T22*W22","v":0},{"$f":"2*T23","v":0},{"$f":"X21/AA21","v":{"$error":"#DIV/0!"}},{"$f":"Y21/AA21","v":{"$error":"#DIV/0!"}},{"$f":"Z21/AA21","v":{"$error":"#DIV/0!"}}]
[null,"Left Leg",5,null,null,null,"Head Restraint Post Pt. 2 (unweighted)",null,null,null,null,null,null,null,null,null,{"$f":"H23 - H21","v":0},{"$f":"I23 - I21","v":0},{"$f":"J23 - J21","v":0},{"$f":"Q22^2 + R22^2 + S22^2","v":0},{"$f":"R23*S21 - S23*R21","v":0},{"$f":"S23*Q21 - Q23*S21","v":0},{"$f":"Q23*R21 - R23*Q21","v":0}]
[null,"Torso Angle without Head",{"$f":"H4","v":0},{"$f":"90-C23","v":90},null,null,"Head Restraint Post Pt. 3 (unweighted)",null,null,null,null,null,null,null,null,null,{"$f":"R21*S22 - S21*R22","v":0},{"$f":"S21*Q22 - Q21*S22","v":0},{"$f":"Q21*R22 - R21*Q22","v":0},{"$f":"Q23^2 + R23^2 + S23^2","v":0}]
[null,null,null,null,null,null,"Center of Head Restraint Post (unweighted)",{"$f":"IF(H21=\"\", \"\", IF(AND(H22=\"\",H23=\"\"), H21, IF(H23=\"\", \"Take Pt.3\", Q24)))","v":""},{"$f":"IF(I21=\"\", \"\", IF(AND(I22=\"\",I23=\"\"), I21, IF(I23=\"\", \"Take Pt.3\", R24)))","v":""},"",null,null,null,null,null,null,{"$f":"H21 + AB21","v":{"$error":"#DIV/0!"}},{"$f":"I21 + AC21","v":{"$error":"#DIV/0!"}},{"$f":"J21 + AD21","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,"Center of Recliner (unweighted)"]
[null,"HRMD by CMM Measurements",null,null,null,null,"Down Rear horizontal"]
[null,null,null,null,null,null,"Down Rear vertical"]
[null,null,"Horizontal","Vertical",null,null,"Up Rear horizontal"]
[null,"Test Position",{"$f":"IF(C39=\"\",\"\",('Footrest Positioning'!F2)*($C$39-C41))","v":""},{"$f":"IF(E40=\"\",\"\",('Footrest Positioning'!F4)*(E42-$E$40))","v":""},null,null,"Up Rear vertical"]
[null,"Down Rearward",{"$f":"IF(C43=\"\",\"\",('Footrest Positioning'!F2)*($C$39-C43))","v":""},{"$f":"IF(E44=\"\",\"\",('Footrest Positioning'!F4)*(E44-$E$40))","v":""},null,null,"Up Forward horizontal"]
[null,"Up Rearward",{"$f":"IF(C45=\"\",\"\",('Footrest Positioning'!F2)*($C$39-C45))","v":""},{"$f":"IF(E46=\"\",\"\",('Footrest Positioning'!F4)*(E46-$E$40))","v":""},null,null,"Up Forward vertical"]
[null,"Up Forward",{"$f":"IF(C47=\"\",\"\",('Footrest Positioning'!F2)*($C$39-C47))","v":""},{"$f":"IF(E48=\"\",\"\",('Footrest Positioning'!F4)*(E48-$E$40))","v":""},null,null,"Down Forward horizontal"]
[null,"Down Forward",{"$f":"IF(C49=\"\",\"\",('Footrest Positioning'!F2)*($C$39-C49))","v":""},{"$f":"IF(E50=\"\",\"\",('Footrest Positioning'!F4)*(E50-$E$40))","v":""},null,null,"Down Forward vertical"]
[]
[null,null,"X","Y","Z"]
[null,"H-Point (right)",{"$f":"H10-$H$9","v":0},{"$f":"I10-$I$9","v":0},{"$f":"J10-$J$9","v":0},{"$f":"ABS(C36-C37)","v":0}]
[null,"H-Point (left)",{"$f":"H11-$H$9","v":0},{"$f":"I11-$I$9","v":0},{"$f":"J11-$J$9","v":0}]
[null,"Head Reference Point",{"$f":"IF(C39 = \"\", \"\", C39+'Footrest Positioning'!F2*101)","v":""},null,{"$f":"IF(E39 = \"\", \"\",  E39)","v":""}]
[null,"Horizontal Head",{"$f":"IF(OR(H10 = \"\", H11 = \"\"), \"\", AVERAGE(C36,C37)-'Footrest Positioning'!F2*(504.5*SIN(RADIANS(D23-2.6))+71))","v":""},null,{"$f":"IF(OR(J10 = \"\", J11 = \"\"), \"\", AVERAGE(E36,E37)-'Footrest Positioning'!F4*(504.5*COS(RADIANS(D23-2.6))+203))","v":""}]
[null,"Vertical Head",null,null,{"$f":"IF(E39 = \"\", \"\", E39 - 'Footrest Positioning'!F4*92)","v":""}]
[null,"Test Position horizontal",{"$f":"H12-$H$9","v":0},{"$f":"I12-$I$9","v":0},{"$f":"J12-$J$9","v":0}]
[null,"Test Position vertical",{"$f":"H13-$H$9","v":0},{"$f":"I13-$I$9","v":0},{"$f":"J13-$J$9","v":0}]
[null,"Down Rear horizontal",{"$f":"IF(H26=\"\", \"\", H26-$H$9)","v":""},{"$f":"IF(I26=\"\", \"\", I26-$I$9)","v":""},{"$f":"IF(J26=\"\", \"\", J26-$J$9)","v":""}]
[null,"Down Rear vertical","","",""]
[null,"Up Rear horizontal","","",""]
[null,"Up Rear vertical","","",""]
[null,"Up Forward horizontal","","",""]
[null,"Up Forward vertical","","",""]
[null,"Down Forward horizontal","","",""]
[null,"Down Forward vertical","","",""]
["Final Position","Center of Recliner",{"$f":"IF(H18=\"\", \"\", H18-$H$9)","v":""},{"$f":"IF(I18=\"\", \"\", I18-$I$9)","v":""},{"$f":"IF(J18=\"\", \"\", J18-$J$9)","v":""}]
[null,"Center of Head Restraint Post",{"$f":"IF(H17=\"\", \"\", H17-$H$9)","v":""},{"$f":"IF(I17=\"\", \"\", I17-$I$9)","v":""},{"$f":"IF(J17=\"\", \"\", J17-$J$9)","v":""}]
["Target Position","Center of Recliner",{"$f":"IF(L8 = \"\", \"\", 'Footrest Positioning'!C12-'Footrest Positioning'!F2*L8)","v":""},{"$f":"IF(M8=\"\",\"\",IF(ABS('Footrest Positioning'!M3)>ABS(M4),'Footrest Positioning'!D12+'Footrest Positioning'!F3*M8,'Footrest Positioning'!D12-'Footrest Positioning'!F3*M8))","v":""},{"$f":"IF(N8 = \"\", \"\", 'Footrest Positioning'!E11-'Footrest Positioning'!F4*N8)","v":""}]
[null,"Center of Head Restraint Post",{"$f":"IF(C53 = \"\", \"\", C53 - 'Footrest Positioning'!F2*L9)","v":""},{"$f":"IF(D53 = \"\", \"\", D53 + 'Footrest Positioning'!F3*M9)","v":""},{"$f":"IF(E53 = \"\", \"\", E53 - 'Footrest Positioning'!F4*N9)","v":""}]
["Final Position \n(unweighted)","Center of Recliner (unweighted)",{"$f":"IF(H25=\"\", \"\", H25-$H$9)","v":""},{"$f":"IF(I25=\"\", \"\", I25-$I$9)","v":""},{"$f":"IF(J25=\"\", \"\", J25-$J$9)","v":""}]
[null,"Center of Head Restraint Post (unweighted)",{"$f":"IF(H24=\"\", \"\", H24-$H$9)","v":""},{"$f":"IF(I24=\"\", \"\", I24-$I$9)","v":""},{"$f":"IF(J24=\"\", \"\", J24-$J$9)","v":""}]
[null,"Test Position horizontal (unweighted)",{"$f":"IF(H19=\"\", \"\", H19-$H$9)","v":""},{"$f":"IF(I19=\"\", \"\", I19-$I$9)","v":""},{"$f":"IF(J19=\"\", \"\", J19-$J$9)","v":""}]
[null,"Test Position vertical (unweighted)",{"$f":"IF(H20=\"\", \"\", H20-$H$9)","v":""},{"$f":"IF(I20=\"\", \"\", I20-$I$9)","v":""},{"$f":"IF(J20=\"\", \"\", J20-$J$9)","v":""}]

{"sheet":"HRMD (Verified)","index":5,"n_rows":51,"n_cols":10,"rows_kept":51,"cut":false,"hidden":false,"merged":[[0,6,0,9],[36,5,37,5],[16,4,16,5],[18,1,19,1],[16,2,16,3],[0,1,4,4],[17,2,17,3],[17,4,17,5],[13,1,14,1],[8,1,9,1],[12,2,12,4],[11,2,11,4],[10,2,10,4],[25,1,26,1]]}
["Coordinate System",null,null,null,null,null,"Data Point Collection"]
[{"$f":"'Footrest Positioning'!A2","v":"X positive forward"},null,null,null,null,null,"Measurements","Value","Units"]
[{"$f":"'Footrest Positioning'!A3","v":"Y positive rightward"},null,null,null,null,null,"Seatback Angle (unweighted)",null,"degrees"]
[{"$f":"'Footrest Positioning'!A4","v":"Z positive downward"},null,null,null,null,null,"Torso Angle",null,"degrees"]
[null,null,null,null,null,null,"Seatback Angle (weighted)",null,"degrees"]
[null,"All coordinates are recorded in mm",null,null,null,null,"Thigh Angle",null,"degrees"]
[]
["1.3.2 H-point manikin installation",null,null,null,null,null,"CMM Collection","X (mm)","Y (mm)","Z (mm)"]
[null,"Test Information",null,null,null,null,"Origin (IIHS origin by default)",{"$f":"'Footrest Positioning'!H10","v":0},{"$f":"'Footrest Positioning'!I10","v":0},{"$f":"'Footrest Positioning'!J10","v":0}]
[null,null,null,null,null,null,"H-Point (right)"]
[null,"Test ID",null,null,null,null,"H-Point (left)"]
[null,"Year/Make/Model",null,null,null,null,"Test Position horizontal"]
[null,"Seat Positioning Procedure",{"$f":"IF(HRMD!C13=\"Select Procedure\",\"\",HRMD!C13)","v":"Version 3.0"},null,null,null,"Test Position vertical"]
[null,"Seat Information",null,null,null,null,"Down Rear horizontal"]
[null,null,"Weighted","Unweighted",null,"Thigh Angle","Down Rear vertical"]
[null,"Seatback Angle",{"$f":"H5","v":0},{"$f":"H3","v":0},null,{"$f":"H6","v":0},"Up Rear horizontal"]
[null,"HR \"Test Position\" Height Adjustment Description",null,null,null,null,"Up Rear vertical"]
[null,"HR \"Test Position\" Tilt Adjustment Description",null,null,null,null,"Up Forward horizontal"]
[null,"HRMD Information",null,null,null,null,"Up Forward vertical"]
[null,null,null,null,null,null,"Down Forward horizontal"]
[null,"Right Leg",5,null,null,null,"Down Forward vertical"]
[null,"Left Leg",5]
[null,"Torso Angle without Head",{"$f":"H4","v":0},{"$f":"90-C23","v":90}]
[]
[]
[null,"HRMD by CMM Measurements"]
[]
[null,null,"Horizontal","Vertical"]
[null,"Test Position",{"$f":"IF(C40=\"\",\"\",('Footrest Positioning'!F2)*($C$40-C42))","v":""},{"$f":"IF(E41=\"\",\"\",('Footrest Positioning'!F4)*(E43-$E$41))","v":""},{"$f":"IF(C29=\"\",\"\",IF(OR('Footrest Positioning'!F2*C29<('Footrest Positioning'!F2)*(HRMD!C29)-5,'Footrest Positioning'!F2*C29>('Footrest Positioning'!F2)*(HRMD!C29)+5),\"Fail\",\"In Tolerance\"))","v":""},{"$f":"IF(D29=\"\",\"\",IF(OR('Footrest Positioning'!F4*D29<('Footrest Positioning'!F4)*(HRMD!D29)-5,'Footrest Positioning'!F4*D29>('Footrest Positioning'!F4)*(HRMD!D29)+5),\"Fail\",\"In Tolerance\"))","v":""}]
[null,"Down Rearward",{"$f":"IF(C44=\"\",\"\",('Footrest Positioning'!F2)*($C$40-C44))","v":""},{"$f":"IF(E45=\"\",\"\",('Footrest Positioning'!F4)*(E45-$E$41))","v":""},{"$f":"IF(C30=\"\",\"\",IF(OR('Footrest Positioning'!F2*C30<('Footrest Positioning'!F2)*(HRMD!C30)-5,'Footrest Positioning'!F2*C30>('Footrest Positioning'!F2)*(HRMD!C30)+5),\"Fail\",\"In Tolerance\"))","v":""},{"$f":"IF(D30=\"\",\"\",IF(OR('Footrest Positioning'!F4*D30<('Footrest Positioning'!F4)*(HRMD!D30)-5,'Footrest Positioning'!F4*D30>('Footrest Positioning'!F4)*(HRMD!D30)+5),\"Fail\",\"In Tolerance\"))","v":""}]
[null,"Up Rearward",{"$f":"IF(C46=\"\",\"\",('Footrest Positioning'!F2)*($C$40-C46))","v":""},{"$f":"IF(E47=\"\",\"\",('Footrest Positioning'!F4)*(E47-$E$41))","v":""},{"$f":"IF(C31=\"\",\"\",IF(OR('Footrest Positioning'!F2*C31<('Footrest Positioning'!F2)*(HRMD!C31)-5,'Footrest Positioning'!F2*C31>('Footrest Positioning'!F2)*(HRMD!C31)+5),\"Fail\",\"In Tolerance\"))","v":""},{"$f":"IF(D31=\"\",\"\",IF(OR('Footrest Positioning'!F4*D31<('Footrest Positioning'!F4)*(HRMD!D31)-5,'Footrest Positioning'!F4*D31>('Footrest Positioning'!F4)*(HRMD!D31)+5),\"Fail\",\"In Tolerance\"))","v":""}]
[null,"Up Forward",{"$f":"IF(C48=\"\",\"\",('Footrest Positioning'!F2)*($C$40-C48))","v":""},{"$f":"IF(E49=\"\",\"\",('Footrest Positioning'!F4)*(E49-$E$41))","v":""},{"$f":"IF(C32=\"\",\"\",IF(OR('Footrest Positioning'!F2*C32<('Footrest Positioning'!F2)*(HRMD!C32)-5,'Footrest Positioning'!F2*C32>('Footrest Positioning'!F2)*(HRMD!C32)+5),\"Fail\",\"In Tolerance\"))","v":""},{"$f":"IF(D32=\"\",\"\",IF(OR('Footrest Positioning'!F4*D32<('Footrest Positioning'!F4)*(HRMD!D32)-5,'Footrest Positioning'!F4*D32>('Footrest Positioning'!F4)*(HRMD!D32)+5),\"Fail\",\"In Tolerance\"))","v":""}]
[null,"Down Forward",{"$f":"IF(C50=\"\",\"\",('Footrest Positioning'!F2)*($C$40-C50))","v":""},{"$f":"IF(E51=\"\",\"\",('Footrest Positioning'!F4)*(E51-$E$41))","v":""},{"$f":"IF(C33=\"\",\"\",IF(OR('Footrest Positioning'!F2*C33<('Footrest Positioning'!F2)*(HRMD!C33)-5,'Footrest Positioning'!F2*C33>('Footrest Positioning'!F2)*(HRMD!C33)+5),\"Fail\",\"In Tolerance\"))","v":""},{"$f":"IF(D33=\"\",\"\",IF(OR('Footrest Positioning'!F4*D33<('Footrest Positioning'!F4)*(HRMD!D33)-5,'Footrest Positioning'!F4*D33>('Footrest Positioning'!F4)*(HRMD!D33)+5),\"Fail\",\"In Tolerance\"))","v":""}]
[]
[null,null,"X","Y","Z"]
[null,null,{"$f":"IF(C37=\"\",\"\",IF(OR('Footrest Positioning'!F2*C37<('Footrest Positioning'!F2)*(HRMD!C36)-5,'Footrest Positioning'!F2*C37>('Footrest Positioning'!F2)*(HRMD!C36)+5),\"Fail\",\"In Tolerance\"))","v":"In Tolerance"},{"$f":"IF(D37=\"\",\"\",IF(OR('Footrest Positioning'!F3*D37<('Footrest Positioning'!F3)*(HRMD!D36)-5,'Footrest Positioning'!F3*D37>('Footrest Positioning'!F3)*(HRMD!D36)+5),\"Fail\",\"In Tolerance\"))","v":"In Tolerance"},{"$f":"IF(E37=\"\",\"\",IF(OR('Footrest Positioning'!F4*E37<('Footrest Positioning'!F4)*(HRMD!E36)-5,'Footrest Positioning'!F4*E37>('Footrest Positioning'!F4)*(HRMD!E36)+5),\"Fail\",\"In Tolerance\"))","v":"In Tolerance"}]
[null,"H-Point (right)",{"$f":"H10-$H$9","v":0},{"$f":"I10-$I$9","v":0},{"$f":"J10-$J$9","v":0},{"$f":"ABS(C37-C38)","v":0}]
[null,"H-Point (left)",{"$f":"H11-$H$9","v":0},{"$f":"I11-$I$9","v":0},{"$f":"J11-$J$9","v":0}]
[null,"Head Reference Point",{"$f":"IF(C40 = \"\", \"\", C40+'Footrest Positioning'!F2*101)","v":""},null,{"$f":"IF(E40 = \"\", \"\",  E40)","v":""}]
[null,"Horizontal Head",{"$f":"IF(OR(H10 = \"\", H11 = \"\"), \"\", AVERAGE(C37,C38)-'Footrest Positioning'!F2*(504.5*SIN(RADIANS(D23-2.6))+71))","v":""},null,{"$f":"IF(OR(J10 = \"\", J11 = \"\"), \"\", AVERAGE(E37,E38)-'Footrest Positioning'!F4*(504.5*COS(RADIANS(D23-2.6))+203))","v":""}]
[null,"Vertical Head",null,null,{"$f":"IF(E40 = \"\", \"\", E40 - 'Footrest Positioning'!F4*92)","v":""}]
[null,"Test Position horizontal",{"$f":"H12-$H$9","v":0},{"$f":"I12-$I$9","v":0},{"$f":"J12-$J$9","v":0}]
[null,"Test Position vertical",{"$f":"H13-$H$9","v":0},{"$f":"I13-$I$9","v":0},{"$f":"J13-$J$9","v":0}]
[null,"Down Rear horizontal",{"$f":"IF(H14=\"\", \"\", H14-$H$9)","v":""},{"$f":"IF(I14=\"\", \"\", I14-$I$9)","v":""},{"$f":"IF(J14=\"\", \"\", J14-$J$9)","v":""}]
[null,"Down Rear vertical","","",""]
[null,"Up Rear horizontal","","",""]
[null,"Up Rear vertical","","",""]
[null,"Up Forward horizontal","","",""]
[null,"Up Forward vertical","","",""]
[null,"Down Forward horizontal","","",""]
[null,"Down Forward vertical","","",""]

{"sheet":"BioRID","index":6,"n_rows":78,"n_cols":30,"rows_kept":78,"cut":false,"hidden":false,"merged":[[76,0,77,0],[38,4,39,4],[38,5,39,5],[17,4,17,5],[25,1,26,1],[36,1,37,1],[18,2,18,3],[19,1,20,1],[17,2,17,3],[0,6,0,9],[0,1,4,4],[12,1,13,1],[16,2,16,3],[16,4,16,5],[8,1,9,1],[10,2,10,4],[11,2,11,4]]}
["Coordinate System",null,null,null,null,null,"Data Point Collection"]
[{"$f":"'Footrest Positioning'!A2","v":"X positive forward"},null,null,null,null,null,"Measurements","Value","Units"]
[{"$f":"'Footrest Positioning'!A3","v":"Y positive rightward"},null,null,null,null,null,"Seatback Angle",null,"degrees"]
[{"$f":"'Footrest Positioning'!A4","v":"Z positive downward"},null,null,null,null,null,"Post Test Seatback Angle",null,"degrees"]
[null,null,null,null,null,null,"Pelvic Angle",null,"degrees"]
[null,"All coordinates are recorded in mm"]
[null,null,null,null,null,null,"CMM Collection","X (mm)","Y (mm)","Z (mm)"]
["1.3.4 BioRID Positioning",null,null,null,null,null,"Origin (IIHS origin by default)",{"$f":"'Footrest Positioning'!H10","v":0},{"$f":"'Footrest Positioning'!I10","v":0},{"$f":"'Footrest Positioning'!J10","v":0}]
[null,"Test Information",null,null,null,null,"H-Point (left)"]
[null,null,null,null,null,null,"H-Point (right)"]
[null,"Test ID",null,null,null,null,"Head CG"]
[null,"Year/Make/Model",null,null,null,null,"Horizontal Head"]
[null,"Seat Information",null,null,null,null,"Vertical Head"]
[null,null,null,null,null,null,"Test Position horizontal"]
[null,"Seatback Angle",{"$f":"H3","v":0},null,null,null,"Test Position vertical"]
[null,"Post Test Seatback Angle",{"$f":"H4","v":0},null,null,null,"Center of Recliner (dummy)"]
[null,"HR \"Test Position\" Height Adjustment Description",null,null,null,null,"Head Restraint Post Pt. 1 (dummy)",null,null,null,null,null,null,null,null,null,{"$f":"H18 - H17","v":0},{"$f":"I18 - I17","v":0},{"$f":"J18 - J17","v":0},{"$f":"Q17^2 + R17^2 + S17^2","v":0},{"$f":"R18*S19 - S18*R19","v":0},{"$f":"S18*Q19 - Q18*S19","v":0},{"$f":"Q18*R19 - R18*Q19","v":0},{"$f":"T17*U17 + T18*U18","v":0},{"$f":"T17*V17 + T18*V18","v":0},{"$f":"T17*W17 + T18*W18","v":0},{"$f":"2*T19","v":0},{"$f":"X17/AA17","v":{"$error":"#DIV/0!"}},{"$f":"Y17/AA17","v":{"$error":"#DIV/0!"}},{"$f":"Z17/AA17","v":{"$error":"#DIV/0!"}}]
[null,"HR \"Test Position\" Tilt Adjustment Description",null,null,null,null,"Head Restraint Post Pt. 2 (dummy)",null,null,null,null,null,null,null,null,null,{"$f":"H19 - H17","v":0},{"$f":"I19 - I17","v":0},{"$f":"J19 - J17","v":0},{"$f":"Q18^2 + R18^2 + S18^2","v":0},{"$f":"R19*S17 - S19*R17","v":0},{"$f":"S19*Q17 - Q19*S17","v":0},{"$f":"Q19*R17 - R19*Q17","v":0}]
[null,"Head Restraint Tested Position",null,null,null,null,"Head Restraint Post Pt. 3 (dummy)",null,null,null,null,null,null,null,null,null,{"$f":"R17*S18 - S17*R18","v":0},{"$f":"S17*Q18 - Q17*S18","v":0},{"$f":"Q17*R18 - R17*Q18","v":0},{"$f":"Q19^2 + R19^2 + S19^2","v":0}]
[null,"BioRID Information",null,null,null,null,"Center of Head Restraint Post (dummy)",{"$f":"IF(H17=\"\", \"\", IF(AND(H18=\"\",H19=\"\"), H17, IF(H19=\"\", \"Take Pt.3\", Q20)))","v":""},{"$f":"IF(I17=\"\", \"\", IF(AND(I18=\"\",I19=\"\"), I17, IF(I19=\"\", \"Take Pt.3\", R20)))","v":""},"",null,null,null,null,null,null,{"$f":"H17 + AB17","v":{"$error":"#DIV/0!"}},{"$f":"I17 + AC17","v":{"$error":"#DIV/0!"}},{"$f":"J17 + AD17","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,"Left Knee center"]
[null,"Pelvic Angle",{"$f":"H5","v":0},null,{"$f":"IF(C22>29,\"Too High\",IF(C22<24,\"Too Low\",\"Good\"))","v":"Too Low"},null,"Right Knee center"]
[null,"T1 Angle",null,null,null,null,"Left Ankle center"]
[null,null,null,null,null,null,"Right Ankle center"]
[null,null,null,null,null,null,"Down Rear horizontal"]
[null,"BioRID Target Measures from HRMD",null,null,null,null,"Down Rear vertical"]
[null,null,null,null,null,null,"Up Rear horizontal"]
[null,null,"Horizontal","Vertical",null,null,"Up Rear vertical"]
[null,"BioRID H-Point Calculated Target",{"$f":"AVERAGE(HRMD!C36,HRMD!C37)+('Footrest Positioning'!F2)*20","v":20},{"$f":"AVERAGE(HRMD!E36,HRMD!E37)","v":0},null,null,"Up Forward horizontal"]
[null,null,null,null,null,null,"Up Forward vertical"]
[null,"Select position","Horizontal","Vertical",null,null,"Down Forward horizontal"]
[null,"Test Position",{"$f":"IF(HRMD!C29=\"\",\"\",HRMD!C29+('Footrest Positioning'!F2)*15)","v":""},{"$f":"IF(HRMD!D29=\"\",\"\",HRMD!D29)","v":""},null,null,"Down Forward vertical"]
[null,"Down Rearward",{"$f":"IF(HRMD!C30=\"\",\"\",HRMD!C30+('Footrest Positioning'!F2)*15)","v":""},{"$f":"IF(HRMD!D30=\"\",\"\",HRMD!D30)","v":""}]
[null,"Up Rearward",{"$f":"IF(HRMD!C31=\"\",\"\",HRMD!C31+('Footrest Positioning'!F2)*15)","v":""},{"$f":"IF(HRMD!D31=\"\",\"\",HRMD!D31)","v":""}]
[null,"Up Forward",{"$f":"IF(HRMD!C32=\"\",\"\",HRMD!C32+('Footrest Positioning'!F2)*15)","v":""},{"$f":"IF(HRMD!D32=\"\",\"\",HRMD!D32)","v":""}]
[null,"Down Forward",{"$f":"IF(HRMD!C33=\"\",\"\",HRMD!C33+('Footrest Positioning'!F2)*15)","v":""},{"$f":"IF(HRMD!D33=\"\",\"\",HRMD!D33)","v":""}]
[null,"BioRID Actual Pre-test Measurements"]
[]
[null,null,"Horizontal","Vertical",{"$f":"IF(C43=\"\", \"\", \"Horizontal \nSkew\")","v":""},{"$f":"IF(D43=\"\", \"\", \"Vertical\nSkew\")","v":""}]
[null,"BioRID H-Point Actual (left)",{"$f":"C58","v":0},{"$f":"E58","v":0}]
[null,"H-Point in Range",{"$f":"IF('Footrest Positioning'!F2*C40>('Footrest Positioning'!F2*C29+10),\"Move Back\",IF('Footrest Positioning'!F2*C40<('Footrest Positioning'!F2*C29-10),\"Move Forward\",\"Good\"))","v":"Move Forward"},{"$f":"IF('Footrest Positioning'!F4*D40>('Footrest Positioning'!F4*D29+10),\"Move Up\",IF('Footrest Positioning'!F4*D40<('Footrest Positioning'!F4*D29-10),\"Move Down\",\"Good\"))","v":"Good"}]
[null,"(mm)",{"$f":"IF(C41=\"Good\",\"\",IF(C41=\"Move Back\",('Footrest Positioning'!F2*C40-('Footrest Positioning'!F2*C29+10)),IF(C41=\"Move Forward\",(('Footrest Positioning'!F2*C29-10)-'Footrest Positioning'!F2*C40))))","v":10},{"$f":"IF(D41=\"Good\",\"\",IF(D41=\"Move Up\",('Footrest Positioning'!F4*D40-('Footrest Positioning'!F4*(D29+10))),IF(D41=\"Move Down\",(('Footrest Positioning'!F4*(D29-10))-'Footrest Positioning'!F4*D40))))","v":""},{"$f":"IF(C43=\"\",\".\",ABS(C40-C43))","v":"."},{"$f":"IF(D43=\"\", \".\", ABS(D40-D43))","v":"."}]
[null,"BioRID H-Point Actual (right)",{"$f":"IF(H10=\"\", \"\", C59)","v":""},{"$f":"IF(J10=\"\", \"\", E59)","v":""}]
[null,"H-Point in Range",{"$f":"IF(C43=\"\", \"\", IF('Footrest Positioning'!F2*C43>('Footrest Positioning'!F2*C29+10),\"Move Back\",IF('Footrest Positioning'!F2*C43<('Footrest Positioning'!F2*C29-10),\"Move Forward\",\"Good\")))","v":""},{"$f":"IF(D43= \"\", \"\", IF('Footrest Positioning'!F4*D43>('Footrest Positioning'!F4*D29+10),\"Move Up\",IF('Footrest Positioning'!F4*D43<('Footrest Positioning'!F4*D29-10),\"Move Down\",\"Good\")))","v":""}]
[null,"(mm)",{"$f":"IF(C43=\"\", \"\", IF(C44=\"Good\",\"\",IF(C44=\"Move Back\",('Footrest Positioning'!F2*C43-('Footrest Positioning'!F2*C29+10)),IF(C44=\"Move Forward\",(('Footrest Positioning'!F2*C29-10)-'Footrest Positioning'!F2*C43)))))","v":""},{"$f":"IF(D43=\"\", \"\", IF(D44=\"Good\",\"\",IF(D44=\"Move Up\",('Footrest Positioning'!F4*D43-('Footrest Positioning'!F4*(D29+10))),IF(D44=\"Move Down\",(('Footrest Positioning'!F4*(D29-10))-'Footrest Positioning'!F4*D43)))))","v":""}]
[]
[null,null,"Horizontal","Vertical"]
[null,"Test Position",{"$f":"IF(C63=\"\",\"\",ABS(C63-$C$61))","v":0},{"$f":"IF(E64=\"\",\"\",E64-$E$62)","v":0},{"$f":"IF(C32=\"\", \"\", IF(C48=\"\",\"\",IF('Footrest Positioning'!F2*C48>('Footrest Positioning'!F2*C32+5),\"Too Large\",IF('Footrest Positioning'!F2*C48<('Footrest Positioning'!F2*C32-5),\"Too Small\",\"Good\"))))","v":""},{"$f":"IF(C32=\"\", \"\", IF(C48=\"\",\"\",IF(E48=\"Good\",\"\",IF(E48=\"Too Large\",'Footrest Positioning'!F2*C48-('Footrest Positioning'!F2*C32+5),IF(E48=\"Too Small\",('Footrest Positioning'!F2*C32-5)-'Footrest Positioning'!F2*C48)))))","v":""}]
[null,"Down Rearward",{"$f":"IF(C65=\"\",\"\",ABS(C65-$C$61))","v":""},{"$f":"IF(E66=\"\",\"\",E66-$E$62)","v":""},{"$f":"IF(C49=\"\",\"\",IF('Footrest Positioning'!F2*C49>('Footrest Positioning'!F2*C33+5),\"Too Large\",IF('Footrest Positioning'!F2*C49<('Footrest Positioning'!F2*C33-5),\"Too Small\",\"Good\")))","v":""},{"$f":"IF(C49=\"\",\"\",IF(E49=\"Good\",\"\",IF(E49=\"Too Large\",'Footrest Positioning'!F2*C49-('Footrest Positioning'!F2*C33+5),IF(E49=\"Too Small\",('Footrest Positioning'!F2*C33-5)-'Footrest Positioning'!F2*C49))))","v":""}]
[null,"Up Rearward",{"$f":"IF(C67=\"\",\"\",ABS(C67-$C$61))","v":""},{"$f":"IF(E68=\"\",\"\",E68-$E$62)","v":""},{"$f":"IF(C50=\"\",\"\",IF('Footrest Positioning'!F2*C50>('Footrest Positioning'!F2*C34+5),\"Too Large\",IF('Footrest Positioning'!F2*C50<('Footrest Positioning'!F2*C34-5),\"Too Small\",\"Good\")))","v":""},{"$f":"IF(C50=\"\",\"\",IF(E50=\"Good\",\"\",IF(E50=\"Too Large\",'Footrest Positioning'!F2*C50-('Footrest Positioning'!F2*C34+5),IF(E50=\"Too Small\",('Footrest Positioning'!F2*C34-5)-'Footrest Positioning'!F2*C50))))","v":""}]
[null,"Up Forward",{"$f":"IF(C69=\"\",\"\",ABS(C69-$C$61))","v":""},{"$f":"IF(E70=\"\",\"\",E70-$E$62)","v":""},{"$f":"IF(C51=\"\",\"\",IF('Footrest Positioning'!F2*C51>('Footrest Positioning'!F2*C35+5),\"Too Large\",IF('Footrest Positioning'!F2*C51<('Footrest Positioning'!F2*C35-5),\"Too Small\",\"Good\")))","v":""},{"$f":"IF(C51=\"\",\"\",IF(E51=\"Good\",\"\",IF(E51=\"Too Large\",'Footrest Positioning'!F2*C51-('Footrest Positioning'!F2*C35+5),IF(E51=\"Too Small\",('Footrest Positioning'!F2*C35-5)-'Footrest Positioning'!F2*C51))))","v":""}]
[null,"Down Forward",{"$f":"IF(C71=\"\",\"\",ABS(C71-$C$61))","v":""},{"$f":"IF(E72=\"\",\"\",E72-$E$62)","v":""},{"$f":"IF(C52=\"\",\"\",IF('Footrest Positioning'!F2*C52>('Footrest Positioning'!F2*C36+5),\"Too Large\",IF('Footrest Positioning'!F2*C52<('Footrest Positioning'!F2*C36-5),\"Too Small\",\"Good\")))","v":""},{"$f":"IF(C52=\"\",\"\",IF(E52=\"Good\",\"\",IF(E52=\"Too Large\",'Footrest Positioning'!F2*C52-('Footrest Positioning'!F2*C36+5),IF(E52=\"Too Small\",('Footrest Positioning'!F2*C36-5)-'Footrest Positioning'!F2*C52))))","v":""}]
[]
[null,"Knee Distance",{"$f":"ABS(D73-D74)","v":0},null,{"$f":"IF(C54=\"\",\"\",IF(C54>210,\"Too Large\",IF(C54<190,\"Too Small\",\"Good\")))","v":"Too Small"},{"$f":"IF(C54=\"\",\"\",IF(E54=\"Good\",\"\",IF(E54=\"Too Large\",(C54-210),IF(E54=\"Too Small\",(190-C54)))))","v":190}]
[null,"Ankle Distance",{"$f":"ABS(D75-D76)","v":0},null,{"$f":"IF(C55=\"\",\"\",IF(C55>210,\"Too Large\",IF(C55<190,\"Too Small\",\"Good\")))","v":"Too Small"},{"$f":"IF(C55=\"\",\"\",IF(E55=\"Good\",\"\",IF(E55=\"Too Large\",(C55-210),IF(E55=\"Too Small\",(190-C55)))))","v":190}]
[]
[null,null,"X","Y","Z"]
[null,"H-Point (left)",{"$f":"H9-$H$8","v":0},{"$f":"I9-$I$8","v":0},{"$f":"J9-$J$8","v":0}]
[null,"H-Point (right)",{"$f":"IF(H10=\"\", \"\", H10-$H$8)","v":""},{"$f":"IF(I10=\"\", \"\", I10-$I$8)","v":""},{"$f":"IF(J10=\"\", \"\", J10-$J$8)","v":""}]
[null,"Head CG",0,0,0]
[null,"Horizontal Head",0,0,0]
[null,"Vertical Head",0,0,0]
[null,"Test Position horizontal",0,0,0]
[null,"Test Position vertical",0,0,0]
[null,"Down Rear horizontal",{"$f":"IF(H25 = \"\", \"\", H25-$H$8)","v":""},{"$f":"IF(I25 = \"\", \"\", I25-$I$8)","v":""},{"$f":"IF(J25 = \"\", \"\", J25-$J$8)","v":""}]
[null,"Down Rear vertical","","",""]
[null,"Up Rear horizontal","","",""]
[null,"Up Rear vertical","","",""]
[null,"Up Forward horizontal","","",""]
[null,"Up Forward vertical","","",""]
[null,"Down Forward horizontal","","",""]
[null,"Down Forward vertical","","",""]
[null,"Left Knee center",{"$f":"H21-$H$8","v":0},{"$f":"I21-$I$8","v":0},{"$f":"J21-$J$8","v":0}]
[null,"Right Knee center",{"$f":"H22-$H$8","v":0},{"$f":"I22-$I$8","v":0},{"$f":"J22-$J$8","v":0}]
[null,"Left Ankle center",{"$f":"H23-$H$8","v":0},{"$f":"I23-$I$8","v":0},{"$f":"J23-$J$8","v":0}]
[null,"Right Ankle center",{"$f":"H24-$H$8","v":0},{"$f":"I24-$I$8","v":0},{"$f":"J24-$J$8","v":0}]
["Final Position","Center of Recliner (dummy)",{"$f":"IF(H16=\"\", \"\", H16-$H$8)","v":""},{"$f":"IF(I16=\"\", \"\", I16-$I$8)","v":""},{"$f":"IF(J16=\"\", \"\", J16-$J$8)","v":""}]
[null,"Center of Head Restraint Post (dummy)",{"$f":"IF(H20=\"\", \"\", H20-$H$8)","v":""},{"$f":"IF(I20=\"\", \"\", I20-$I$8)","v":""},{"$f":"IF(J20=\"\", \"\", J20-$J$8)","v":""}]

{"sheet":"Summary","index":7,"n_rows":33,"n_cols":11,"rows_kept":33,"cut":false,"hidden":false,"merged":[[0,7,0,8],[5,0,5,1],[0,9,0,10],[8,0,8,8]]}
["Hpoint Position",null,"Pelvis","Torso","Pre SB","Post SB","Max SB","Head Restraint",null,"HRMD Head Restraint"]
["Horiz","Vert","Angle","Angle","Angle","Angle","Deflection","Backset","Vert","Backset","Vert"]
[{"$f":"BioRID!C40","v":0},{"$f":"BioRID!D40","v":0},{"$f":"BioRID!C22","v":0},{"$f":"HRMD!D23","v":90},{"$f":"BioRID!C15","v":0},{"$f":"BioRID!C16","v":0},null,{"$f":"IF(BioRID!$C$19=BioRID!$B$48,BioRID!C48,IF(BioRID!$C$19=BioRID!$B$49,BioRID!C49,IF(BioRID!$C$19=BioRID!$B$50,BioRID!C50,IF(BioRID!$C$19=BioRID!$B$51,BioRID!C51,IF(BioRID!$C$19=BioRID!$B$52,BioRID!C52)))))","v":false},{"$f":"IF(BioRID!$C$19=BioRID!$B$48,BioRID!D48,IF(BioRID!$C$19=BioRID!$B$49,BioRID!D49,IF(BioRID!$C$19=BioRID!$B$50,BioRID!D50,IF(BioRID!$C$19=BioRID!$B$51,BioRID!D51,IF(BioRID!$C$19=BioRID!$B$52,BioRID!D52)))))","v":false},{"$f":"HRMD!C29","v":""},{"$f":"HRMD!D29","v":""}]
[]
[]
[]
[]
["Seat Description"]
[{"$f":"C21&C22&C23&C24&C25&C26&C27&C28&C29&C30&C31&C32&C33","v":";  HR"}]
[]
[]
["HR Position Height Adjustment"]
[{"$f":"IF(BioRID!$C$19=\"Test Position\",BioRID!C17&\" \"&BioRID!E17,BioRID!C19)","v":0}]
[]
["HR Position Tilt Adjustment"]
[{"$f":"IF(BioRID!$C$19=\"Test Position\",BioRID!C18& \" \"&BioRID!E18,BioRID!C19)","v":0}]
[]
[]
[]
[]
["Material",{"$f":"IF('Seat Set-up'!C11=\"\",\"\",'Seat Set-up'!C11)","v":""},{"$f":"IF(B21=\"\",\"\",B21)","v":""}]
[" track",{"$f":"IF(OR('Seat Set-up'!C12=\"\",'Seat Set-up'!C12=\"Fixed\"),\"\",'Seat Set-up'!C12)","v":""},{"$f":"IF(B22=\"\",\"\",\"; \"&B22&A22)","v":""}]
[" seat back",{"$f":"IF(OR('Seat Set-up'!C13=\"\",'Seat Set-up'!C13=\"Fixed\"),\"\",'Seat Set-up'!C13)","v":""},{"$f":"IF(B23=\"\",\"\",\"; \"&B23&A23)","v":""}]
[" seat height",{"$f":"IF(OR('Seat Set-up'!C14=\"\",'Seat Set-up'!C14=\"Fixed\"),\"\",'Seat Set-up'!C14)","v":""},""]
[" seat tilt",{"$f":"IF(OR('Seat Set-up'!C15=\"\",'Seat Set-up'!C15=\"Fixed\"),\"\",'Seat Set-up'!C15)","v":""},""]
[" seat cushion height",{"$f":"IF(OR('Seat Set-up'!C16=\"\",'Seat Set-up'!C16=\"Fixed\"),\"\",'Seat Set-up'!C16)","v":""},""]
[" seat cushion tilt",{"$f":"IF(OR('Seat Set-up'!C17=\"\",'Seat Set-up'!C17=\"Fixed\"),\"\",'Seat Set-up'!C17)","v":""},""]
[" lumbar",{"$f":"IF(OR('Seat Set-up'!C18=\"\",'Seat Set-up'!C18=\"Fixed\"),\"\",'Seat Set-up'!C18)","v":""},""]
[" upper seat back of a two point articulating seat back",{"$f":"IF(OR('Seat Set-up'!C19=\"\",'Seat Set-up'!C19=\"Fixed\"),\"\",'Seat Set-up'!C19)","v":""},""]
[" cushion extension",{"$f":"IF(OR('Seat Set-up'!C20=\"\",'Seat Set-up'!C20=\"Fixed\"),\"\",'Seat Set-up'!C20)","v":""},""]
[" side bolster",{"$f":"IF(OR('Seat Set-up'!C21=\"\",'Seat Set-up'!C21=\"Fixed\"),\"\",'Seat Set-up'!C21)","v":""},""]
["Heated",{"$f":"IF('Seat Set-up'!C22=\"Equipped\",\"heated\",\"\")","v":""},{"$f":"IF(B32=\"\",\"\",\"; \"&B32)","v":""}]
["Anti-whiplash mechanism",{"$f":"IF('Seat Set-up'!C29=\"None\",\"\",CONCATENATE('Seat Set-up'!C29, \" \", \"HR\"))","v":" HR"},{"$f":"IF(B33=\"\",\"\",\"; \"&B33)","v":";  HR"}]

{"sheet":"Additional points","index":8,"n_rows":77,"n_cols":17,"rows_kept":77,"cut":false,"hidden":false,"merged":[[12,5,12,7],[37,0,37,3],[60,0,60,3],[0,11,0,14],[69,0,69,3],[1,0,1,3],[8,0,8,3],[12,0,12,3]]}
["Measurement point","X","Y","Z",null,null,null,null,null,null,null,"Data Point Collection"]
["Dummy",null,null,null,null,null,null,null,null,null,null,"CMM Collection","X (mm)","Y (mm)","Z (mm)"]
["T1 vertebrae point 1 (forward)",{"$f":"M4-$M$3","v":0},{"$f":"N4-$N$3","v":0},{"$f":"O4-$N$3","v":0},null,null,null,null,null,null,null,"Origin (IIHS origin by default)",{"$f":"'Footrest Positioning'!H10","v":0},{"$f":"'Footrest Positioning'!I10","v":0},{"$f":"'Footrest Positioning'!J10","v":0}]
["T1 vertebrae point 2 (rearward)",{"$f":"M5-$M$3","v":0},{"$f":"N5-$N$3","v":0},{"$f":"O5-$N$3","v":0},null,null,null,null,null,null,null,"T1 vertebrae point 1 (forward)"]
[null,null,null,null,null,null,null,null,null,null,null,"T1 vertebrae point 2 (rearward)"]
[null,null,null,null,null,null,null,null,null,null,null,"D-ring location"]
[null,null,null,null,null,null,null,null,null,null,null,"Seatbelt lateral anchor location"]
[null,null,null,null,null,null,null,null,null,null,null,"Buckle location"]
["Seat",null,null,null,null,null,null,null,null,null,"Left ","Sled point 1 (front)"]
["D-ring location (webbing central contact point with re-routing slot)",{"$f":"M6-$M$3","v":0},{"$f":"N6-$N$3","v":0},{"$f":"O6-$O$3","v":0},null,null,null,null,null,null,"Left ","Sled point 2 (rear)"]
["Seatbelt lateral anchor location",{"$f":"M7-$M$3","v":0},{"$f":"N7-$N$3","v":0},{"$f":"O7-$O$3","v":0},null,null,null,null,null,null,"Left ","Sled point 3 (rear)"]
["Buckle location",0,0,0,null,null,null,null,null,null,"Left ","Sled point 4 (front)"]
["Motion tracking (Left side points_seat outboard)",null,null,null,null,"Motion tracking (Right side points_seat inboard)",null,null,null,null,"Left ","Head COG"]
["Sled point 1 (front)",{"$f":"M9-$M$3","v":0},{"$f":"N9-$N$3","v":0},{"$f":"O9-$O$3","v":0},null,{"$f":"M28-$M$3","v":0},{"$f":"N28-$N$3","v":0},{"$f":"O28-$O$3","v":0},null,null,"Left ","Head 2 (Chin or upper head)",null,null,null,null,"match OEM points where applicable"]
["Sled point 2 (rear)",{"$f":"M10-$M$3","v":0},{"$f":"N10-$N$3","v":0},{"$f":"O10-$O$3","v":0},null,{"$f":"M29-$M$3","v":0},{"$f":"N29-$N$3","v":0},{"$f":"O29-$O$3","v":0},null,null,"Left ","Occipital condyle",null,null,null,null,"Make sure buckle doesn't interfere with motion analysis"]
["Sled point 3 (rear)",0,0,0,null,0,0,0,null,null,"Left ","T1"]
["Sled point 4 (front)",0,0,0,null,0,0,0,null,null,"Left ","T1 Flag point 1 (front)"]
["Head COG",0,0,0,null,0,0,0,null,null,"Left ","T1 Flag point 2 (rear)"]
["Head 2 (Chin or upper head)",0,0,0,null,0,0,0,null,null,"Left ","Pelvis flag point 1 (front)"]
["Occipital condyle",0,0,0,null,0,0,0,null,null,"Left ","Pelvis flag point 2 (rear)"]
["T1",0,0,0,null,0,0,0,null,null,"Left ","Upper HR"]
["T1 Flag point 1 (front)",0,0,0,null,0,0,0,null,null,"Left ","Lower HR"]
["T1 Flag point 2 (rear)",0,0,0,null,0,0,0,null,null,"Left ","Upper SB"]
["Pelvis flag point 1 (front)",0,0,0,null,0,0,0,null,null,"Left ","Lower SB"]
["Pelvis flag point 2 (rear)",0,0,0,null,0,0,0,null,null,"Left ","Recliner"]
[null,null,null,null,null,null,null,null,null,null,"Left ","Recliner (Sticker Y actual)"]
[null,null,null,null,null,null,null,null,null,null,"Left ","Seat cushion"]
[null,null,null,null,null,null,null,null,null,null,"Right ","Sled point 1 (front)"]
[null,null,null,null,null,null,null,null,null,null,"Right ","Sled point 2 (rear)"]
[null,null,null,null,null,null,null,null,null,null,"Right ","Sled point 3 (rear)"]
["Upper HR",{"$f":"M21-$M$3","v":0},{"$f":"N21-$N$3","v":0},{"$f":"O21-$O$3","v":0},null,{"$f":"M40-$M$3","v":0},{"$f":"N40-$N$3","v":0},{"$f":"O40-$O$3","v":0},null,null,"Right ","Sled point 4 (front)"]
["Lower HR",{"$f":"M22-$M$3","v":0},{"$f":"N22-$N$3","v":0},{"$f":"O22-$O$3","v":0},null,{"$f":"M41-$M$3","v":0},{"$f":"N41-$N$3","v":0},{"$f":"O41-$O$3","v":0},null,null,"Right ","Head COG"]
["Upper SB",0,0,0,null,0,0,0,null,null,"Right ","Head 2 (Chin or upper head)"]
["Lower SB",0,0,0,null,0,0,0,null,null,"Right ","Occipital condyle"]
["Recliner",0,{"$f":"N26-$N$3","v":0},0,null,0,{"$f":"N45-$N$3","v":0},0,null,null,"Right ","T1"]
["Seat cushion",{"$f":"M27-$M$3","v":0},{"$f":"N27-$N$3","v":0},{"$f":"O27-$O$3","v":0},null,{"$f":"M46-$M$3","v":0},{"$f":"N46-$N$3","v":0},{"$f":"O46-$O$3","v":0},null,null,"Right ","T1 Flag point 1 (front)"]
[null,null,null,null,null,null,null,null,null,null,"Right ","T1 Flag point 2 (rear)"]
[null,null,null,null,null,null,null,null,null,null,"Right ","Pelvis flag point 1 (front)"]
[null,null,null,null,null,null,null,null,null,null,"Right ","Pelvis flag point 2 (rear)"]
[null,null,null,null,null,null,null,null,null,null,"Right ","Upper HR"]
[null,null,null,null,null,null,null,null,null,null,"Right ","Lower HR"]
[null,null,null,null,null,null,null,null,null,null,"Right ","Upper SB"]
[null,null,null,null,null,null,null,null,null,null,"Right ","Lower SB"]
[null,null,null,null,null,null,null,null,null,null,"Right ","Recliner"]
[null,null,null,null,null,null,null,null,null,null,"Right ","Recliner (Sticker Y actual)"]
[null,null,null,null,null,null,null,null,null,null,"Right ","Seat cushion"]
[null,null,null,null,null,null,null,null,null,null,"Cam 1 ","Camera and lens pair"]
[null,null,null,null,null,null,null,null,null,null,"Cam 1 ","Top near end of lens"]
[null,null,null,null,null,null,null,null,null,null,"Cam 1 ","Bottom near end of lens"]
[null,null,null,null,null,null,null,null,null,null,"Cam 1 ","Point 1"]
[null,null,null,null,null,null,null,null,null,null,"Cam 1 ","Point 2"]
[null,null,null,null,null,null,null,null,null,null,"Cam 1 ","Point 3"]
[null,null,null,null,null,null,null,null,null,null,"Cam 1 ","Point 4"]
[null,null,null,null,null,null,null,null,null,null,"Cam 2 ","Camera and lens pair"]
[null,null,null,null,null,null,null,null,null,null,"Cam 2 ","Top near end of lens"]
[null,null,null,null,null,null,null,null,null,null,"Cam 2 ","Bottom near end of lens"]
[null,null,null,null,null,null,null,null,null,null,"Cam 2 ","Point 1"]
[null,null,null,null,null,null,null,null,null,null,"Cam 2 ","Point 2"]
[null,null,null,null,null,null,null,null,null,null,"Cam 2 ","Point 3"]
[null,null,null,null,null,null,null,null,null,null,"Cam 2 ","Point 4"]
["Camera 1"]
["Camera and lens pair",{"$f":"M47","v":0},{"$f":"N47","v":0},0]
["Top near end of lens",{"$f":"M48","v":0},{"$f":"N48","v":0},{"$f":"O48","v":0}]
["Bottom near end of lens",0,0,0]
["Point 1",0,0,0]
["Point 2",0,0,0]
["Point 3",0,0,0]
["Point 4",0,0,0]
[]
["Camera 2"]
["Camera and lens pair",{"$f":"M54","v":0},{"$f":"N54","v":0},0]
["Top near end of lens",{"$f":"M55","v":0},{"$f":"N55","v":0},{"$f":"O55","v":0}]
["Bottom near end of lens",0,0,0]
["Point 1",0,0,0]
["Point 2",0,0,0]
["Point 3",0,0,0]
["Point 4",0,0,0]

{"sheet":"Data Share","index":9,"n_rows":29,"n_cols":5,"rows_kept":29,"cut":false,"hidden":false,"merged":[[27,2,27,3],[27,4,27,5],[28,2,28,3],[28,4,28,5],[0,1,1,4],[2,1,3,4]]}
["Coordinate System",{"$f":"IF(BioRID!C11 = \"\", \"\", BioRID!C11)","v":""}]
[{"$f":"'Footrest Positioning'!A2","v":"X positive forward"}]
[{"$f":"'Footrest Positioning'!A3","v":"Y positive rightward"},{"$f":"IF(BioRID!C12=\"\", \"\", BioRID!C12)","v":""}]
[{"$f":"'Footrest Positioning'!A4","v":"Z positive downward"}]
[null,null,"X (mm)","Y (mm)","Z (mm)"]
[null,"Outboard seat track reference point",{"$f":"'Footrest Positioning'!C11","v":""},{"$f":"'Footrest Positioning'!D11","v":""},{"$f":"'Footrest Positioning'!E11","v":""}]
[null,"Left front seatbolt",{"$f":"'Footrest Positioning'!C12","v":""},{"$f":"'Footrest Positioning'!D12","v":""},{"$f":"'Footrest Positioning'!E12","v":""}]
[null,"Right front seatbolt",{"$f":"'Footrest Positioning'!C13","v":""},{"$f":"'Footrest Positioning'!D13","v":""},{"$f":"'Footrest Positioning'!E13","v":""}]
[null,"Right rear seatbolt",{"$f":"'Footrest Positioning'!C14","v":""},{"$f":"'Footrest Positioning'!D14","v":""},{"$f":"'Footrest Positioning'!E14","v":""}]
[null,"Left rear seatbolt",{"$f":"'Footrest Positioning'!C15","v":""},{"$f":"'Footrest Positioning'!D15","v":""},{"$f":"'Footrest Positioning'!E15","v":""}]
[]
[null,"Center of Recliner (unweighted)",{"$f":"HRMD!C55","v":""},{"$f":"HRMD!D55","v":""},{"$f":"HRMD!E55","v":""}]
[null,"Center of Head Restraint Post (unweighted)",{"$f":"HRMD!C56","v":""},{"$f":"HRMD!D56","v":""},{"$f":"HRMD!E56","v":""}]
[null,"HRP @ Test Position (unweighted)",{"$f":"IF(HRMD!H19=\"\", \"\", HRMD!H19-HRMD!H9)","v":""},{"$f":"IF(HRMD!I19=\"\", \"\", HRMD!I19-HRMD!I9)","v":""},{"$f":"IF(HRMD!J19=\"\", \"\", HRMD!J19-HRMD!J9)","v":""}]
[null,"Highest Point on Head Restraint (unweighted)",{"$f":"IF(HRMD!H20=\"\", \"\", HRMD!H20-HRMD!H9)","v":""},{"$f":"IF(HRMD!I20=\"\", \"\", HRMD!I20-HRMD!I9)","v":""},{"$f":"IF(HRMD!J20=\"\", \"\", HRMD!J20-HRMD!J9)","v":""}]
[null,"Heel Point",{"$f":"'Footrest Positioning'!C43","v":{"$error":"#N/A"}},{"$f":"'Footrest Positioning'!D43","v":{"$error":"#N/A"}},{"$f":"'Footrest Positioning'!E43","v":{"$error":"#N/A"}}]
[]
[null,"Center of Recliner (weighted)",{"$f":"HRMD!C51","v":""},{"$f":"HRMD!D51","v":""},{"$f":"HRMD!E51","v":""}]
[null,"Center of Head Restraint Post (weighted)",{"$f":"HRMD!C52","v":""},{"$f":"HRMD!D52","v":""},{"$f":"HRMD!E52","v":""}]
[null,"HRP @ Test Position (weighted)",{"$f":"HRMD!C41","v":0},{"$f":"HRMD!D41","v":0},{"$f":"HRMD!E41","v":0}]
[null,"Highest Point on Head Restraint (weighted)",{"$f":"HRMD!C42","v":0},{"$f":"HRMD!D42","v":0},{"$f":"HRMD!E42","v":0}]
[]
[null,"Manikin H-point",{"$f":"AVERAGE(HRMD!C36:C37)","v":0},{"$f":"AVERAGE(HRMD!D36:D37)","v":0},{"$f":"AVERAGE(HRMD!E36:E37)","v":0}]
[null,"Manikin Horizontal Head",{"$f":"HRMD!C39","v":""},null,{"$f":"HRMD!E39","v":""}]
[null,"Manikin Torso Angle (deg)",{"$f":"HRMD!D23","v":90}]
[null,"Manikin Backset",{"$f":"HRMD!C29","v":""}]
[]
[null,"Head Restraint Vertical Adjustment",{"$f":"'Head Restraint Position'!C83","v":"Select New Position"},null,{"$f":"'Head Restraint Position'!E83","v":"Select New Position"}]
[null,"Head Restraint Horizontal Adjustment",{"$f":"'Head Restraint Position'!C84","v":"Select New Position"},null,{"$f":"'Head Restraint Position'!E84","v":"Select New Position"}]